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.
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 to | Date | Status |
|---|---|---|---|
| Mainstream End Date | SQL Server 2016 | July 13, 2021 | Passed |
| Extended End Date | SQL Server 2016 (Service Pack 3) | July 14, 2026 | Passed |
| Extended Security Updates Year 1 (listed end) | Instances with an ESU subscription | July 13, 2027 | Ahead |
| Extended Security Updates Year 2 (listed end) | Instances with an ESU subscription | July 18, 2028 | Ahead |
| Extended Security Updates Year 3 (listed end) | Instances with an ESU subscription | July 17, 2029 | Ahead |
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:
| Path | What it involves | Usually fits when |
|---|---|---|
| Upgrade to SQL Server 2022 | Move databases to SQL Server 2022, in mainstream support to January 11, 2028 and extended support to January 11, 2033 | The application vendor supports SQL Server 2022 |
| Upgrade to SQL Server 2019 | Move to SQL Server 2019, in extended support to January 8, 2030 | The application vendor certifies SQL Server 2019 but not 2022 |
| Subscribe to ESUs as a bridge | Connect 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 licensing | The upgrade depends on an application release that is not ready yet |
| Move to the application vendor's hosted version | Retire the local database when the software moves to the vendor's cloud | The 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.
- Microsoft Lifecycle: SQL Server 2016 (opens in a new tab)
- Microsoft Learn: What are Extended Security Updates for SQL Server? (opens in a new tab)
- Microsoft Lifecycle: SQL Server 2022 (opens in a new tab)
- Microsoft Lifecycle: SQL Server 2019 (opens in a new tab)
- Microsoft Lifecycle: Windows Server 2016 (opens in a new tab)
- Microsoft Lifecycle: Fixed Lifecycle Policy (opens in a new tab)
Related pages
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.
