{"id":74863,"date":"2026-07-01T15:34:12","date_gmt":"2026-07-01T13:34:12","guid":{"rendered":"https:\/\/www.schneider.im\/?p=74863"},"modified":"2026-07-01T16:17:44","modified_gmt":"2026-07-01T14:17:44","slug":"microsoft-sql-server-2016-extended-security-updates-keep-you-protected-past-end-of-support","status":"publish","type":"post","link":"https:\/\/www.schneider.im\/lu\/microsoft-sql-server-2016-extended-security-updates-keep-you-protected-past-end-of-support\/","title":{"rendered":"Microsoft SQL Server 2016: Extended Security Updates Keep You Protected Past End of Support"},"content":{"rendered":"<p><strong>Stay secure and compliant<\/strong> while you plan your database move.<\/p>\n<p>Effective <strong>July 14, 2026<\/strong>, Microsoft <strong>ends support for SQL Server 2016<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-74823\" src=\"https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-LinkedIn-Microsoft-SQL-Server-2016-Extended-Security-Updates-800x526.jpg\" alt=\"\" width=\"800\" height=\"526\" srcset=\"https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-LinkedIn-Microsoft-SQL-Server-2016-Extended-Security-Updates-800x526.jpg 800w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-LinkedIn-Microsoft-SQL-Server-2016-Extended-Security-Updates-500x329.jpg 500w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-LinkedIn-Microsoft-SQL-Server-2016-Extended-Security-Updates-150x99.jpg 150w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-LinkedIn-Microsoft-SQL-Server-2016-Extended-Security-Updates-768x505.jpg 768w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-LinkedIn-Microsoft-SQL-Server-2016-Extended-Security-Updates.jpg 1080w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>Summary<\/h2>\n<ul>\n<li>Microsoft <strong>ends extended support<\/strong> for <strong>SQL Server 2016<\/strong> on <strong>July 14, 2026<\/strong>.<\/li>\n<li><strong>Extended Security Updates (ESU)<\/strong> deliver <strong>critical security patches only<\/strong>, for a maximum of <strong>three years<\/strong>.<\/li>\n<li>Coverage runs through <strong>July 17, 2029<\/strong>, across three annual terms you <strong>buy separately<\/strong>.<\/li>\n<li>ESU pricing is now <strong>consistent across Azure, on-premises, and other clouds<\/strong>.<\/li>\n<li>Only <strong>Enterprise and Standard editions<\/strong> on the <strong>latest Service Pack<\/strong> qualify for ESUs.<\/li>\n<li><strong>Act now:<\/strong> inventory every instance and choose <strong>upgrade, migrate, or ESU<\/strong> before July 2026.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-74811\" src=\"https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-SQL-Server-2016-support-and-Extended-Security-Updates-timeline-800x369.png\" alt=\"\" width=\"800\" height=\"369\" srcset=\"https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-SQL-Server-2016-support-and-Extended-Security-Updates-timeline-800x369.png 800w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-SQL-Server-2016-support-and-Extended-Security-Updates-timeline-500x231.png 500w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-SQL-Server-2016-support-and-Extended-Security-Updates-timeline-150x69.png 150w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-SQL-Server-2016-support-and-Extended-Security-Updates-timeline-768x354.png 768w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-07-01-Update-SQL-Server-2016-support-and-Extended-Security-Updates-timeline.png 1300w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: center;\"><em>SQL Server 2016 support and Extended Security Updates timeline.<\/em><\/p>\n<p>&nbsp;<\/p>\n<h2>What is changing?<\/h2>\n<p>SQL Server 2016 reaches the <strong>end of its support lifecycle<\/strong>. After <strong>July 14, 2026<\/strong>, Microsoft <strong>stops shipping security updates and bug fixes<\/strong> for every edition. <strong>Extended Security Updates (ESU)<\/strong> are the bridge: they deliver <strong>critical security patches for up to three years<\/strong> while you modernize.<\/p>\n<p>Microsoft has also <strong>aligned ESU pricing<\/strong>. ESUs purchased for <strong>Azure<\/strong> now cost the <strong>same as on-premises and other clouds<\/strong> &#8211; one consistent model at <strong>100 percent of the 2025 license cost per year<\/strong>. This consistency applies to the ESU <strong>list price<\/strong>, which is now identical across Azure, on-premises, and other clouds, and across purchasing channels \u2013 including Enterprise Agreement, the Microsoft Customer Agreement, and the Cloud Solution Provider (CSP) program. Existing ESUs for <strong>SQL Server 2014 and Windows Server 2012 are not affected<\/strong>. SQL Server 2016 ESU billing <strong>begins July 15, 2026<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h2>What are Extended Security Updates?<\/h2>\n<p><strong>Extended Security Updates (ESU)<\/strong> are an offering for products that have passed their end of support. They deliver <strong>Security Updates rated Critical<\/strong> by the <strong>Microsoft Security Response Center (MSRC)<\/strong> &#8211; and nothing else. There are <strong>no new features and no non-security fixes<\/strong>, and technical support is limited to the released updates.<\/p>\n<p>Within the Microsoft ecosystem, ESUs sit <strong>alongside Software Assurance (SA) and Azure<\/strong> -. For SQL Server 2016, they cover <strong>Enterprise and Standard editions<\/strong> and are licensed by <strong>virtual cores (v-cores)<\/strong> or <strong>physical cores (p-cores)<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h2>Customer benefits at a glance<\/h2>\n<ul>\n<li>Keep regulated workloads <strong>updated against newly discovered critical threats<\/strong>.<\/li>\n<li>Hold your <strong>audit and compliance posture<\/strong> under frameworks that require current updates.<\/li>\n<li>Buy time for a <strong>planned migration<\/strong>.<\/li>\n<li><strong>Pay only for the coverage you use<\/strong> when you subscribe through Azure Arc.<\/li>\n<li><strong>Stop paying immediately<\/strong> once you upgrade or migrate to a supported platform.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2>Key capabilities<\/h2>\n<ul>\n<li><strong>Critical Security Updates<\/strong> delivered if and when available, on the <strong>latest Service Pack<\/strong>.<\/li>\n<li><strong>Three enrollment paths<\/strong>: Azure pay-as-you-go, an Azure Arc subscription, or volume licensing with Software Assurance.<\/li>\n<li>Licensing by <strong>v-cores (4-core minimum per virtual machine)<\/strong> or by <strong>p-cores<\/strong> for host-level and unlimited virtualization.<\/li>\n<li><strong>Automatic installation<\/strong> on Azure Arc-connected instances that have automatic updates enabled.<\/li>\n<li>Coverage that <strong>continues on Azure SQL after migration<\/strong>, with ESU charges stopping automatically.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2>How to enroll<\/h2>\n<p>You can subscribe to SQL Server 2016 ESUs through <strong>four routes<\/strong>. The right one depends on <strong>where the workload runs<\/strong> and whether your licenses carry <strong>active Software Assurance (SA)<\/strong>.<\/p>\n<table width=\"624\">\n<thead>\n<tr>\n<td width=\"147\"><strong>Enrollment path<\/strong><\/td>\n<td width=\"260\"><strong>How it works<\/strong><\/td>\n<td width=\"217\"><strong>Software Assurance<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td width=\"147\"><strong>Azure VMs \/ Azure SQL<\/strong><\/td>\n<td width=\"260\">ESUs charged through your Azure subscription when SQL Server 2016 runs on Azure.<\/td>\n<td width=\"217\">Not required (pay-as-you-go)<\/td>\n<\/tr>\n<tr>\n<td width=\"147\"><strong>Azure Arc subscription<\/strong><\/td>\n<td width=\"260\">Connect on-premises servers with Azure Arc and subscribe; pay monthly for what you use.<\/td>\n<td width=\"217\">Optional (pay-as-you-go or bring your own license)<\/td>\n<\/tr>\n<tr>\n<td width=\"147\"><strong>Volume licensing with SA<\/strong><\/td>\n<td width=\"260\">Buy annual ESUs under Enterprise Agreement (EA), Enterprise Subscription Agreement (EAS), Server and Cloud Enrollment (SCE), or Enrollment for Education Solutions (EES) with active Software Assurance.<\/td>\n<td width=\"217\">Required<\/td>\n<\/tr>\n<tr>\n<td width=\"147\"><strong>Cloud Solution Provider (CSP)<\/strong><\/td>\n<td width=\"260\">Purchase SQL Server 2016 ESUs through a CSP partner in Partner Center, either as an Azure Arc subscription or as annual volume-licensing SKUs.<\/td>\n<td width=\"217\">Required for VL SKUs; not required via Azure Arc pay-as-you-go<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Subscribing through <strong>Azure Arc<\/strong>: connect the server, open the <strong>SQL Server Configuration<\/strong> pane, and turn on the <strong>Extended Security Updates<\/strong> subscription.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-74835\" src=\"https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-06-29-Update-SQL-Server-ESU-800x533.png\" alt=\"\" width=\"800\" height=\"533\" srcset=\"https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-06-29-Update-SQL-Server-ESU-800x533.png 800w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-06-29-Update-SQL-Server-ESU-500x333.png 500w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-06-29-Update-SQL-Server-ESU-150x100.png 150w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-06-29-Update-SQL-Server-ESU-768x512.png 768w, https:\/\/www.schneider.im\/media\/2026\/07\/SCHNEIDER-IT-MANAGEMENT-2026-06-29-Update-SQL-Server-ESU.png 975w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: center;\"><em>Subscribing to Extended Security Updates in the Azure portal (Azure Arc, SQL Server Configuration).<\/em><\/p>\n<p>&nbsp;<\/p>\n<h2>Why this is relevant now<\/h2>\n<p>Support ends <strong>July 14, 2026<\/strong>. Running an <strong>unsupported database raises security risk<\/strong>. Acting early gives you <strong>control over budget<\/strong> and avoids a rushed migration.<\/p>\n<p>Windows Server 2016 follows the <strong>same end-of-support pattern<\/strong>. To coordinate both moves, see our guidance on <a href=\"https:\/\/www.schneider.im\/lu\/microsoft-windows-and-windows-server-2016-prepare-for-end-of-support\/\">preparing for Windows and Windows Server 2016 end of support<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h2>What organizations should do now<\/h2>\n<ul>\n<li><strong>Review<\/strong> every SQL Server 2016 instance, edition, and core count across <strong>production, test, and development<\/strong>.<\/li>\n<li><strong>Validate<\/strong> that each instance runs the <strong>latest Service Pack<\/strong>, because ESUs apply only on the current Service Pack.<\/li>\n<li><strong>Identify<\/strong> which workloads can <strong>upgrade to SQL Server 2022 or 2025<\/strong>, migrate to Azure SQL, or need ESUs.<\/li>\n<li><strong>Compare<\/strong> the three enrollment paths and confirm whether your licenses carry <strong>active Software Assurance<\/strong>.<\/li>\n<li><strong>Update<\/strong> your fiscal-year budget for ESU costs.<\/li>\n<li><strong>Monitor<\/strong> renewal dates and plan migrations to <strong>stop ESU charges as early as possible<\/strong>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-71872\" src=\"https:\/\/www.schneider.im\/media\/2026\/03\/Office-People-DSCF8526-800x533.webp\" alt=\"\" width=\"800\" height=\"533\" srcset=\"https:\/\/www.schneider.im\/media\/2026\/03\/Office-People-DSCF8526-800x533.webp 800w, https:\/\/www.schneider.im\/media\/2026\/03\/Office-People-DSCF8526-500x333.webp 500w, https:\/\/www.schneider.im\/media\/2026\/03\/Office-People-DSCF8526-150x100.webp 150w, https:\/\/www.schneider.im\/media\/2026\/03\/Office-People-DSCF8526-768x512.webp 768w, https:\/\/www.schneider.im\/media\/2026\/03\/Office-People-DSCF8526-1536x1024.webp 1536w, https:\/\/www.schneider.im\/media\/2026\/03\/Office-People-DSCF8526-2048x1365.webp 2048w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>Ready to optimize your SQL Server 2016 licensing?<\/h2>\n<p>Our <strong>Microsoft licensing experts<\/strong> help you <strong>compare upgrade, migration, and ESU costs<\/strong>, confirm your <strong>Software Assurance coverage<\/strong>, and choose the best enrollment path. <a href=\"https:\/\/www.schneider.im\/contact\/\"><strong>Contact us<\/strong><\/a> to plan your SQL Server 2016 licensing strategy with confidence.<\/p>\n<p>&nbsp;<\/p>\n<h2>Sources<\/h2>\n<p><em>For the announcement of Microsoft SQL Server 2016 Extended Security Updates, please visit: <\/em><a href=\"https:\/\/techcommunity.microsoft.com\/blog\/sqlserver\/sql-server-2016-extended-security-updates-stay-protected-while-you-modernize\/4529478\"><em>https:\/\/techcommunity.microsoft.com\/blog\/sqlserver\/sql-server-2016-extended-security-updates-stay-protected-while-you-modernize\/4529478<\/em><\/a><em>.<\/em><\/p>\n<p><em>For useful software licensing information on Microsoft products, please visit: <\/em><a href=\"https:\/\/www.schneider.im\/software\/microsoft\/\"><em>https:\/\/www.schneider.im\/software\/microsoft\/<\/em><\/a><em>.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Stay secure and compliant while you plan your database move. Effective July 14, 2026, Microsoft ends support for SQL Server 2016. Summary Microsoft ends extended support for SQL Server 2016 on July 14, 2026. Extended Security Updates (ESU) deliver critical security patches only, for a maximum of three years. Coverage runs through July 17, 2029, [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":33016,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[147],"tags":[],"class_list":["post-74863","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-sql-server"],"_links":{"self":[{"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/posts\/74863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/comments?post=74863"}],"version-history":[{"count":2,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/posts\/74863\/revisions"}],"predecessor-version":[{"id":74887,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/posts\/74863\/revisions\/74887"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/media\/33016"}],"wp:attachment":[{"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/media?parent=74863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/categories?post=74863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.schneider.im\/lu\/wp-json\/wp\/v2\/tags?post=74863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}