Tag: EOL

End of Support Windows Server 2012 Extended Security Updates for Windows Server and SQL Server in Azure and Azure Stack

Extended Security Updates for Windows Server and SQL Server in Azure and Azure Stack

Windows Server is an essential workload platform for almost every organization, and is one of the most popular operating systems in Azure. Microsoft Azure and Azure Stack HCI offer additional benefits to Windows Server such as the Windows Server 2022 Azure Edition which includes features like hotpatch as part of Azure Automanage and many other things. An additional capacity of running Windows Server in Azure or on Azure Stack HCI, Hub, and Edge, is that you get extended security updates (ESU) included for free for Windows Server and SQL Server which are out of mainstream support. This applies to Windows Server 2008 and 2008 R2 and will soon apply to Windows Server 2012 and 2012 R2 when it reaches end of support, plus the corresponding versions of SQL Server.

Let’s have a quick look at your options with End of Support for Windows Server 2012, 2012 R2 and SQL Server 2012. In this blog I tried to provide you with a brief overview as well as links to the necessary resources.

Disclaimer: This post is only to help customer to find the right resources and evaluate their options. Only information from official Microsoft resources are valide.

End of Support for Windows Server 2012, 2012 R2 and SQL Server 2012

SQL Server 2012 and Windows Server 2012, and 2012 R2 End of Extended support is coming:

  • SQL Server 2012 Extended Support will end on July 12, 2022.
  • Windows Server 2012 and 2012 R2 Extended Support will end on October 10, 2023.
End of Support Windows Server and SQL Server 2012
End of Support Windows Server and SQL Server 2012

Options for SQL Server 2012 and Windows Server 2012 End of Support

The best way to address this is of course to upgrade and modernize the latest versions of SQL Server 2022 and Windows Server 2022 or modernize to Azure PaaS services. However, some organizations need some additional time to modernize their platform and environment. For these customer Microsoft offers Extended Security Updates (ESU).

  • In Azure and on-premises (hybrid): Customers running SQL Server 2012 and Windows Server 2012 and 2012 R2 in Azure will get Extended Security Updates for free. Free Extended Security Updates are available for Azure Virtual Machines including Azure Dedicated Host, Azure VMWare Solution, Azure Nutanix Solution, and Azure Stack (Hub, Edge, and HCI).
  • On-premises (no Azure): Customers with active Software Assurance or subscription licenses can purchase Extended Security Updates annually for 75 percent of the license cost of the latest version of SQL Server or Windows Server for the first year, 100 percent of the license cost for the second year, and 125 percent of the license cost for the third year. Customers pay for only the servers they need to cover, so they can reduce costs each year as they upgrade parts of their environment.

You can learn more on the blog from Debbi Lyons (Director, Product Marketing, Azure SQL and Database Migration) and Vijay Kumar (Director, Product Marketing, Windows Server and Azure Arc) here.

End of Support Windows Server 2012 Extended Security Updates for Windows Server and SQL Server in Azure and Azure Stack
End of Support Windows Server 2012 Extended Security Updates for Windows Server and SQL Server in Azure and Azure Stack

If you are looking at a migration to Microsoft Azure, check out my YouTube video on how to migrate servers to Azure using Azure Migrate.

Obtain Windows Server and SQL Server 2012 Extended Security Updates (ESU)

  • In Azure, you can obtain Windows Server Extended Security Updates automatically to your Azure virtual machine through Windows Server Update Service. 
  • Get your SQL Server Extended Security Updates in Azure by registering your subscription with the SQL Server IaaS Agent extension. Learn more about registering your SQL Server virtual machine with the IaaS Agent extension.
  • On-premises, your Windows Server Extended Security Updates will be delivered as any regular Windows Server Update.  
  • On-premises SQL Server Extended Security Updates can be obtained by connecting your SQL Server to Azure Arc.

Additional Resources

  • Support for Windows Server 2012, Windows Server 2012 R2, and SQL Server 2012 Extended Security Updates (ESU) on Azure Stack HCI was announced during Microsoft Ignite 2021.
  • You can learn more about Extended Security Updates (ESU) and end-of-support for Windows Server 2012/2012 R2 and SQL Server 2012 on microsoft.com.
  • If you want to learn how to use Extended Security Updates (ESU) for Windows Server, check out Microsoft Docs.

Conclusion

I hope this blog provides you with an overview of you option for the end-of-support for Windows Server 2012, 2012 R2 and SQL Server 2012, and how you can leverage Azure and Azure Stack to get free Extended Security Updates (ESU). If you have any question, feel free to leave a comment below.



Extended Security Updates for SQL Server and Windows Server 2008 and 2008 R2 on Azure Stack

Extended Security Updates for SQL Server and Windows Server 2008 and 2008 R2 on Azure Stack

SQL Server and Windows Server 2008 and 2008 R2 will both be out of extended support within the next 12 months (detailed dates below). This means if you have these versions, you’ll need to migrate to newer versions of SQL Server or Windows Server or buy Extended Support soon to maintain support and receive security updates and fixes. Buying Extended Support is not cheap. Customers with active Software Assurance or subscription licenses can purchase Extended Security Updates annually for 75 percent of the full license cost of the latest version of SQL Server or Windows Server. A lot of customers should start migrating to newer versions of these products to avoid these extra costs.

Extended Support dates

  • Extended Support for SQL Server 2008 and 2008 R2 will end on July 9, 2019.
  • Extended Support for Windows Server 2008 and 2008 R2 will end on January 14, 2020.

However, in mid-2018 Microsoft announced a new option for SQL Server 2008 and Windows Server 2008 End of Support. Customers running 2008 or 2008 R2 versions of SQL Server and Windows Server in Azure virtual machines will get Extended Security Updates for free. This will give customers some extra time to migrate to newer versions of SQL Server and Windows Server. Or even better, to Azure PaaS and serverless computing like Azure Functions.

Extended Security Updates on Azure Stack

If you are thinking to migrate to the cloud, this new option will bring down costs for you. However, not everyone is fully ready to move all their servers to the public cloud. You might still need or want to run some servers on-premise in your datacenter. This will leave you with buying Extended Support or what a lot of people don’t know; you can also run your SQL Server and Windows Server 2008 and 2008 R2 on Azure Stack and get Extended Security Updates for free since it is Azure!

This is great, especially since Azure Stack also comes with great IaaS capabilities. And if you are thinking about using Azure in the mid-term, Azure Stack provides you with Azure capabilities, but still allows you to stay in your datacenter.