Skip to main content
End-of-life dates, Microsoft

SQL Server 2016 End of Support: Extended Security Updates Explained

Microsoft's dates for SQL Server 2016, the three paid Extended Security Updates years, how ESUs are obtained, and the upgrade paths for instances still running it.

Servers and databasesMicrosoftDays Dynamics team. Dates checked against the vendor's own lifecycle page on November 13, 2026.

When SQL Server 2016 support ends

SQL Server 2016 reached the end of extended support on July 14, 2026, on Service Pack 3, its last service pack. Microsoft sells Extended Security Updates for it in three yearly periods, and its lifecycle page lists the last one ending July 17, 2029. Microsoft releases ESUs if needed, once a vulnerability is rated Critical, so they buy time to upgrade rather than replace the upgrade.

SQL Server 2016 lifecycle dates

Each row uses Microsoft's own milestone name and the exact scope it applies to.

Milestone (vendor's term)Applies toDateStatus
Mainstream End DateSQL Server 2016July 13, 2021Passed
Extended End DateSQL Server 2016 (Service Pack 3)July 14, 2026Passed
Extended Security Updates Year 1 (listed end)Instances with an ESU subscriptionJuly 13, 2027Ahead
Extended Security Updates Year 2 (listed end)Instances with an ESU subscriptionJuly 18, 2028Ahead
Extended Security Updates Year 3 (listed end)Instances with an ESU subscriptionJuly 17, 2029Ahead

Microsoft lists the three ESU years with an 8:00 AM Pacific Time end, so those rows show the date exactly as listed. Service Pack 3 ended on the same day as extended support.

Source: Microsoft Lifecycle: SQL Server 2016 (opens in a new tab). Vendors move dates, so confirm on that page before a budget or purchase order depends on one.

What it means for a business

Outside an ESU subscription, Microsoft's support for SQL Server 2016 has ended. ESUs are a narrow bridge, and Microsoft spells out what they leave out.

ESUs are released only when needed

Microsoft releases an ESU if needed, once a vulnerability is rated Critical by the Microsoft Security Response Center, so there is no regular release cadence. Each ESU includes the most recent Cumulative Update.

What ESUs exclude

ESUs do not include new features, functional improvements, or customer-requested fixes, and support is limited to deploying, installing, and activating the ESU updates themselves.

No free ESUs on Azure virtual machines

Microsoft says that starting with SQL Server 2016, moving the workload to SQL Server on Azure VMs no longer provides free access to ESUs. Azure VM customers can subscribe through the SQL IaaS Agent extension.

Who is affected

SQL Server often hides inside other software. Look in these places:

  • Database servers running any SQL Server 2016 instance, including instances on Windows Server 2016, which reaches end of support January 12, 2027.
  • Applications that installed their own SQL Server 2016 instance, such as practice management, accounting, or ERP software.
  • Reporting and integration servers that use SQL Server 2016 components.
  • Instances that cannot connect to Azure Arc, which may need ESUs through volume licensing instead.

Your realistic paths

Most SQL Server 2016 instances end up on one of these paths:

PathWhat it involvesUsually fits when
Upgrade to SQL Server 2022Move databases to SQL Server 2022, in mainstream support to January 11, 2028 and extended support to January 11, 2033The application vendor supports SQL Server 2022
Upgrade to SQL Server 2019Move to SQL Server 2019, in extended support to January 8, 2030The application vendor certifies SQL Server 2019 but not 2022
Subscribe to ESUs as a bridgeConnect the instance to Azure Arc and subscribe in the Azure portal; Microsoft says an instance that cannot connect might be eligible for ESUs through volume licensingThe upgrade depends on an application release that is not ready yet
Move to the application vendor's hosted versionRetire the local database when the software moves to the vendor's cloudThe vendor offers a hosted edition that fits

See the SQL Server 2017 end of support guide and how we approach infrastructure end-of-support assessment.

What to check before you decide

  • Every instance and its version. Include instances installed by applications, not only dedicated database servers.
  • Application vendor support. Get the list of SQL Server versions each application supports before choosing a target.
  • The operating system underneath. A SQL Server 2016 instance on Windows Server 2016 faces two deadlines, July 14, 2026 and January 12, 2027, so plan them as one project.
  • Azure Arc readiness. ESUs through Azure Arc need the server connected to Azure; confirm that is allowed in your environment.
  • A tested restore. Restore a recent backup to a test server before the upgrade, so the rollback plan is proven.

How Microsoft's Fixed Lifecycle Policy works

Under Microsoft's Fixed Lifecycle Policy, Mainstream Support includes security updates and the ability to request non-security updates. Extended Support includes security updates at no additional cost, and Microsoft does not accept requests for warranty support, design changes, or new features in that phase. Microsoft shows each end date as 6:59:59 AM Pacific Time on the following morning, so the dates on this page are the last full day.

Frequently asked questions

Is SQL Server 2016 still supported?

Extended support ended July 14, 2026. After that, security fixes come only through a paid Extended Security Updates subscription.

How long can SQL Server 2016 ESUs last?

Microsoft lists three ESU years, and the last one is listed as ending July 17, 2029.

Are SQL Server 2016 ESUs free on Azure VMs?

No. Microsoft says SQL Server 2016 customers can subscribe to ESUs on Azure VMs through the SQL IaaS Agent extension but are not eligible for free ESUs.

Not sure which of your systems this affects?

Send the models and versions you run. A person at Days Dynamics matches each one to its vendor dates and tells you what likely needs a project. It is planning support, not a quote, an audit, or a commitment on licensing, availability, or delivery dates.

Sources

Vendor pages checked on November 13, 2026. Dates and product status can change, so confirm on the source before you rely on them.

Planning around this date?

Find out which of your systems lose support

Send a list of servers, firewalls, and Windows 10 PCs. A person replies, usually within 2 business days, with what loses vendor support, when, and what likely needs a project. Free, with no obligation.