Azure SQL server 2022 images on WS2019

Question

We planning to upgrade our SQL servers on azure VMs from SQL 2016 -WS2012R2 to SQL2022- WS2019. We are not seeing SQL 2022 images with WS2019 available in the marketplace and instead have SQL2022 with WS022. Firstly, is this correct ? if so what's the solution as we only want to go with SQL2022 with WS2019.

Answer 1

Hello @Venkata Yeleswarapu

Thank you for reaching out to the Microsoft Q&A platform.

You are right! SQL Server 2022 with Windows Server 2019 image is not available in the Azure Marketplace currently.
One option you can consider is to create a new Azure VM with Windows Server 2019 and install SQL Server 2022 manually. This would involve selecting the appropriate Windows Server 2019 image from the Azure Marketplace, provisioning a new VM, and then installing SQL Server 2022 on the new VM.

It is important to note that the availability of Azure VM images can vary depending on the region or subscription. To view all available images using PowerShell, use the following command:

Get-AzVMImageOffer -Location $Location -Publisher 'MicrosoftSQLServer'

As per the document, below are the combination available :
https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview?view=azuresql#payasyougo

Note: Regardless of the approach you choose, it is important to thoroughly test your new SQL Server environment before migrating any production workloads to it to ensure that it meets your performance, security, and reliability requirements.

--please don't forget to upvote and Accept as answer if the reply is helpful--

Answer 2

Hi @Prrudram-MSFT

The image SQL2022 on WS019 is still not available in Marketplace.

Any reason why this is not available yet ?