SQL Server Version not showing correctly in Azure - SQL Server on Azure VM

Albano Stefani 0 Reputation points
2023-05-11T14:51:32.45+00:00

Hello everyone,

I upgraded SQL Server Version from 2019 to 2022 following these instructions: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/change-sql-server-version?view=azuresql,

but after the SQL Server version upgrade the SQL Virtual Machine still shows the older version in Portal. What else do I need to so it reflects the correct version for billing purposes? I did re-register the laas extension but it did not fix the issue. Also the VM was rebooted after upgrade.

Thanks,

User's image

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,414 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2023-05-11T16:09:57.9033333+00:00

    When you re-registered the VM with the SQL IaaS Agent Extension, did you perform the delete of the SQL VM resource (NOT the VM) and then re-create? It should have detected the version at the time of creating the SQL VM resource.

    You can check what the SQL IaaS Agent Extension found by looking in:

    *C:\Packages\Plugins\Microsoft.SqlServer.Management.SqlIaaSAgent<latest version>\Status*

    From a billing perspective, the version does not make a difference - it is the edition that matters.

    1 person found this answer helpful.