Azure SQL server 2022 images on WS2019

Venkata Yeleswarapu 0 Reputation points
2023-03-10T19:23:49.7766667+00:00

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.

SQL Server on Azure Virtual Machines
{count} votes

2 answers

Sort by: Most helpful
  1. Prrudram-MSFT 26,841 Reputation points
    2023-03-13T18:20:26.3333333+00:00

    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#payasyougoUser's image

    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--

    0 comments No comments

  2. Kumar Saurav 0 Reputation points
    2023-06-11T09:22:14.08+00:00

    Hi @Prrudram-MSFT

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

    Any reason why this is not available yet ?

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.