Back to blog

OSSeva Blog

Operations

SQL Server 2016 End of Life: ESU Terms, Dates and Your Options

Matt ReynoldsUpdated 8 min read

Dates checked on 20 October 2026 against endoflife.date and Microsoft's lifecycle pages.

Leaving SQL Server?

Migration to PostgreSQL, with 24/7 support afterwards on infrastructure you control. OSSeva does not support or patch SQL Server itself.

SQL Server to PostgreSQL migration →

Only your email is required · An engineer replies within 1 business day · No commitment

The short answer

SQL Server 2016 reached end of support on 14 July 2026. Mainstream support ended on 13 July 2021, and extended support, which delivered security updates only, ended five years later. Microsoft no longer ships security updates for SQL Server 2016 unless you subscribe to Extended Security Updates (ESUs), which run for up to three years, to 17 July 2029, and include Critical updates only. Service Pack 3 was the final service pack.

Weighing ESU against a move? SQL Server ESU cost sets out ESU cost and terms beside the PostgreSQL option, and SQL Server versions and end-of-support dates lists every version from 2012 to 2025.

The server keeps running. What has stopped is the fix supply. The options are to upgrade, move to Azure SQL, pay for ESUs while you plan, or move to another database. The table compares them; SQL Server end of support options sets out the same choices for every version.

OptionWhat you get on SQL Server 2016What it costs you
Upgrade to SQL Server 2022 or 2025A supported version. 2025 accepts an upgrade from 2016 SP3 or later; mainstream support runs to 11 January 2028 (2022) and 6 January 2031 (2025)Licences on Microsoft's terms and application testing
Extended Security Updates (ESU)Critical security updates only, 15 July 2026 to 17 July 2029; Microsoft calls them a temporary bridgeA paid subscription, billed per core; late enrolment is back-billed to July 2026
Azure SQL Managed Instance or DatabaseA managed service that Microsoft says never reaches end of supportYour databases move onto Microsoft's cloud service and its terms
Move to PostgreSQLAn open source database with no per-core licence, on infrastructure you controlA migration sized to each application, then a PostgreSQL support subscription priced per cluster

Dates re-read on Microsoft's SQL Server 2016 lifecycle page, its ESU FAQ and endoflife.date on 17 November 2026. If the application is yours to change, SQL Server to PostgreSQL migration with OSSeva support is the route OSSeva sells; it does not patch SQL Server itself.

SQL Server 2016 lifecycle dates

MilestoneDate
Release1 June 2016
End of mainstream support13 July 2021
End of extended support14 July 2026
ESU Year 115 July 2026 to 13 July 2027
ESU Year 2to 18 July 2028
ESU Year 3to 17 July 2029

Source: the Microsoft Lifecycle page for SQL Server 2016 and the SQL Server ESU FAQ. SQL Server 2016 follows the Fixed Lifecycle Policy, which gives each version at least ten years: five of mainstream support and five of extended support. The extended support end date and the ESU end date were checked against endoflife.date on 20 October 2026 and again on 17 November 2026. For the other versions, see SQL Server 2017 (12 October 2027) and SQL Server 2019 (8 January 2030).

The operating system has a date too: Windows Server 2016 end of support covers the 12 January 2027 end of extended support and the apps on the server.

What end of support means for SQL Server 2016

  • No security updates without ESUs. Vulnerabilities found after 14 July 2026 are not fixed in any public SQL Server 2016 update.
  • No Microsoft technical support for the product, apart from the limited help that comes with an ESU subscription and a qualifying support plan.
  • Compliance findings. An unsupported database engine is a finding under most control frameworks unless you can show a compensating control.
  • Nothing breaks on the day. Licences stay valid, the service keeps running and applications keep connecting.

How SQL Server 2016 Extended Security Updates work

Microsoft calls ESUs "a last resort paid option" and "a temporary bridge" to a supported platform. The terms, from Microsoft's ESU documentation:

  • Scope. Security updates rated Critical by the Microsoft Security Response Center, for up to three years. No new features, functional improvements or customer-requested fixes, and no regular release cadence: an update ships only when a Critical vulnerability needs one.
  • Baseline. ESU packages include the most recent cumulative update. If you applied only GDR updates during support, Microsoft advises installing and validating the latest CU when you subscribe.
  • Where you can get them. On Azure VMs through the SQL IaaS Agent extension, on Azure VMware Solution and Azure Stack, and everywhere else, including on premises and other clouds, by connecting the server to Azure Arc. Servers that cannot connect to Arc can be registered in disconnected mode after buying ESUs through volume licensing.
  • Licensing. On premises you need Software Assurance or subscription licences under a qualifying agreement, or a pay-as-you-go subscription through Azure Arc. SQL Server 2014 instances moved to Azure VMs received ESUs through Windows Update without a subscription; SQL Server 2016 instances on Azure VMs have to subscribe like any other.
  • Billing. Azure bills ESUs hourly. Enrol late and you are back-billed to the end-of-support date: Microsoft's example is a 2016 customer who enrols in January 2027 and is billed for July to December 2026.
  • Support. ESU licences do not include support for SQL Server 2016 itself. Help is limited to deploying, installing and activating the updates, and only under one of the support plans Microsoft lists.

SQL Server 2016 end of support planning: your options

1. Upgrade to a current SQL Server version

SQL Server 2025 supports an upgrade from SQL Server 2016 SP3 or later, so most 2016 servers can move in one step. SQL Server 2022 and 2025 both have mainstream support into 2028 and 2031 respectively. Test with the target compatibility level and Query Tuning Assistant before the cutover.

2. Move to Azure SQL

Azure SQL Managed Instance and Azure SQL Database are, in Microsoft's words, managed services that "never reach end of support". Managed Instance is the closer match for a lift and shift. This changes how you run the database as well as where.

3. Subscribe to ESUs while you plan

Sensible when the upgrade or migration cannot finish before you need the next security fix. Treat the three years as a deadline, not a plan, and remember coverage is Critical updates only.

4. Move to PostgreSQL

For applications you own, an end-of-support date is a natural point to leave SQL Server licensing behind. T-SQL, temporary tables, identity columns and the many ways applications connect make it a real project. The SQL Server to PostgreSQL migration guide covers pgloader, a T-SQL rewrite and Babelfish.

Where OSSeva fits

OSSeva does not support or patch SQL Server, so for an in-place upgrade or ESUs, Microsoft and its partners are the right route. If you decide to leave, OSSeva's SQL Server to PostgreSQL offer assesses each application, moves the data, runs old and new side by side, and supports the PostgreSQL cluster from cutover onwards on infrastructure you control, priced per cluster. The database support cost calculator uses your own figures; book a 15-minute discovery call for a quote.

Frequently asked questions

When is SQL Server 2016 end of support?

14 July 2026. Mainstream support ended on 13 July 2021, and extended support ended on 14 July 2026.

Is SQL Server 2016 end of life?

Yes, in the sense most people mean: Microsoft's support lifecycle for it ended on 14 July 2026. The only security updates after that date are ESUs, which run to 17 July 2029.

What are SQL Server 2016 ESUs?

A paid subscription that delivers Critical security updates for up to three years after end of support, through Azure, Azure Arc or volume licensing. It does not include new features, non-security fixes or general product support.

Do I need Azure to get SQL Server 2016 ESUs?

Not to run SQL Server in Azure. Servers on premises or in other clouds subscribe through Azure Arc, and servers that cannot connect can be registered in disconnected mode after a volume licensing purchase.

Can I upgrade SQL Server 2016 directly to SQL Server 2025?

Yes, from SQL Server 2016 SP3 or later.

What happens if we enrol in ESUs late?

Microsoft back-bills to the end-of-support date, so a January 2027 enrolment is charged from July 2026.

Tags

SQL ServerSQL Server 2016End of SupportExtended Security UpdatesPostgreSQL

Get a quote

Leaving SQL Server? Send your work email.

An OSSeva engineer replies within 1 business day with an assessment plan and a quote, priced per cluster.

Only your email is required · An engineer replies within 1 business day · No commitment

Prefer to talk or read more first?

Book a call