SQL Server 2016 end of support: what healthcare and finance teams should do now
Published 22 October 2026 · dotNew Labs
SQL Server 2016 reached the end of extended support on July 14, 2026. It still runs, but new security fixes now come only through paid Extended Security Updates. For databases that hold patient or financial records, that needs a decision and a date.
Extended support end dates by version. Bars that reach the right edge run past 2033 or end later.
Where your versions stand
Version
Status
SQL Server 2014 and older
Out of support
SQL Server 2016
Out of extended support since July 14, 2026
SQL Server 2017
Extended support ends October 2027
SQL Server 2019, 2022, 2025
Supported
Always confirm dates on Microsoft's lifecycle pages for your exact edition.
Your three options
Upgrade to a supported version. Usually the best long-term answer. Plan for compatibility level changes and test the slowest queries.
Move to a managed database. Azure SQL Managed Instance, Amazon RDS for SQL Server or similar take patching off your plate. Check features you rely on, such as SQL Agent jobs, linked servers and SSIS.
Buy time with Extended Security Updates. Paid yearly, and included at no extra cost when the server runs in Azure. Use it to get a safe window, not as the plan.
What usually breaks in an upgrade
Query plans change under the new compatibility level and a few reports slow down. Query Store helps you spot and pin these.
Old features and syntax that newer versions removed.
Linked servers, SQL Agent jobs, SSIS packages and SSRS reports that nobody listed.
Applications that connect with old drivers or old encryption settings.
A safe order
Inventory instances, databases, jobs, reports and the apps that connect.
Restore a copy on the new version and run the assessment tools.
Test the busiest and most important queries, and reconcile key report totals.
Rehearse the cutover and the rollback, then schedule the window.
Don't forget the apps
An old database usually sits under an old application. If the app is on .NET Framework or WebForms, plan both together, so you change connection settings and test once instead of twice.
Not sure where your apps stand?
We offer a free 20-minute scan of one app: what it runs on, what's risky, and the shortest safe path forward. You keep a short written summary whether or not you hire us.