The SQL virtual machine resource is not in a valid state for management

Question

Through portal.azure.com I am attempting to create a 'SQL Server 2019 Standard on Windows Server 2019' virtual machine. The deployment is in a new subscription so it creates a new RG, networking, IP etc.. for the VM. The deployment succeeds on each step until it reaches the SQL VM and then it fails with an error stating "System Drive returned status not ready for use". At this point I can open the Server 2019 VM and connect to MySql via SSMS. However when looking at the SQL Virtual Machine in the azure portal I see:

Most of the left side-bar is disabled, including the repair function:

I'm not a DBA but this looks like something isn't right. Rebooting the Server 2019 VM doesn't resolve the issue. Can anyone advise on how to bring this SQL virtual machine to a healthy state?

Answer 1

It is the Azure SQL Server IaaS Extension wether not (correctly) installed or some permissions are missing. please check the documentation.

https://learn.microsoft.com/de-de/azure/azure-sql/virtual-machines/windows/sql-agent-extension-manually-register-single-vm

Answer 2

The solution was to run the following command in the linked page:

Register Enterprise or Standard self-installed VM in full mode

az sql vm create --name <vm_name> --resource-group <resource_group_name> --location <vm_location> --license-type <license_type> --sql-mgmt-type Full

This took a few minutes to run and afterwards my existing SQL Virtual Machine cleared it's errors and reported the Status as online and the Edition as standard as expected.

Thanks.