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

Question

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,

Answer 1

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.