SQL Server 2022 on Server 2022 Deployment Failure on Azure

Angel Van de Feniks 1 Reputation point

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,633 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Rahul Randive 5,656 Reputation points Microsoft Employee

    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


    Thank you!