SQL Server 2022 on Server 2022 Deployment Failure on Azure

Question

I'm trying to deploy SQL server 2022 on server 2022 in the Azure environment and keep getting the following error:

{"code":"DeploymentFailed","target":"/subscriptions/01aa8fb1-f6be-45cb-9653-d684d269807d/resourceGroups/azure_phoenix/providers/Microsoft.Resources/deployments/CreateVm-microsoftsqlserver.sql2022-ws2022-sqldev-20231109180512","message":"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.","details":[{"code":"ResourceDeploymentFailure","target":"/subscriptions/01aa8fb1-f6be-45cb-9653-d684d269807d/resourceGroups/azure_phoenix/providers/Microsoft.SqlVirtualMachine/SqlVirtualMachines/phoenixVirtualMachine","message":"The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'."}]}

I've searched the questions but don't see anything related to SQL server 2022 on Azure.

Answer 1

Hi Angel Van de Feniks •

Based on backend log here is the error you are getting for your deployment-

{"statusMessage":"{"status":"Failed","error":{"code":"ResourceOperationFailure","message":"The resource operation completed with terminal provisioning state 'Failed'.","details":[{"code":"Ext_SqlIaasExtensionError","message":"Error: 'Service with name 'MSSQLSERVER' is not running. Please make sure service 'MSSQLSERVER' is running and retry this operation.'"

Please check the SQL IaaS Agent extension and try to repair if the extension status shows as Provisioning failed in the Azure portal. Additionally, you can check if the SQL VM resource is available in the Azure portal and verify that you have the latest version of the SQL IaaS Agent extension.

Be sure to register your SQL Server VM with the SQL IaaS Agent extension to manage your SQL Server VM in the portal. 

Reference document - Known issues and troubleshooting the SQL Server IaaS agent extension - SQL Server on Azure VMs | Microsoft Learn

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-agent-extension-manually-register-single-vm?view=azuresql&tabs=azure-portal

Thank you!