Issue with Deploying Azure SQL Server Managed Instances: “Your deployment failed”

Question

Hello,

I am encountering an issue while trying to deploy Azure SQL Server Managed Instances. The deployment process fails with the message “Your deployment failed.”

I have attached a screenshot of the deployment details and included the error message below. From what I understand, the error seems to be related to incorrect storage account credentials. However, I did not see any option to provide storage account keys during the creation of the Azure SQL Server instance.

Could someone please advise if I am missing something or how I can resolve this issue?

Thank you!

"code": "DeploymentFailed",

"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": "Conflict",

  "message": "{\r\n  \"status\": \"Failed\",\r\n  \"error\": {\r\n    \"code\": \"ResourceDeploymentFailure\",\r\n    \"message\": \"The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.\",\r\n    \"details\": [\r\n      {\r\n        \"code\": \"DeploymentFailed\",\r\n        \"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.\",\r\n        \"details\": [\r\n          {\r\n            \"code\": \"Conflict\",\r\n            \"message\": \"{\\r\\n  \\\"status\\\": \\\"Failed\\\",\\r\\n  \\\"error\\\": {\\r\\n    \\\"code\\\": \\\"ResourceDeploymentFailure\\\",\\r\\n    \\\"message\\\": \\\"The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.\\\",\\r\\n    \\\"details\\\": [\\r\\n      {\\r\\n        \\\"code\\\": \\\"Ext_InvalidStorageAccountCredentials\\\",\\r\\n        \\\"message\\\": \\\"The storage account URL and Access key combination provided is incorrect.\\\"\\r\\n      }\\r\\n    ]\\r\\n  }\\r\\n}\"\r\n          },\r\n          {\r\n            \"code\": \"Conflict\",\r\n            \"message\": \"{\\r\\n  \\\"status\\\": \\\"Failed\\\",\\r\\n  \\\"error\\\": {\\r\\n    \\\"code\\\": \\\"ResourceDeploymentFailure\\\",\\r\\n    \\\"message\\\": \\\"The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.\\\",\\r\\n    \\\"details\\\": [\\r\\n      {\\r\\n        \\\"code\\\": \\\"Ext_InvalidStorageAccountCredentials\\\",\\r\\n        \\\"message\\\": \\\"The storage account URL and Access key combination provided is incorrect.\\\"\\r\\n      }\\r\\n    ]\\r\\n  }\\r\\n}\"\r\n          }\r\n        ]\r\n      }\r\n    ]\r\n  }\r\n}"

}

Answer 1

Hi @DoFast,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Based on the error message, it seems the problem is related to incorrect storage account credentials.

Here are some steps you can take to resolve this:

• Ensure the Storage account URL is correct and accessible.
• Confirm that the access key is valid and hasn’t been regenerated. You can find these details in the Azure portal under your storage account settings
• Ensure that all parameters in your deployment template or command are correct, especially those related to the storage account.
• Ensure that your storage account and SQL Managed Instance are in the same virtual network or have the necessary network configurations to communicate with each other.
• Make sure the managed identity associated with your Azure SQL Managed Instance has the necessary permissions to access the storage account. Assign the Storage Blob Data Contributor role to the managed identity.

For more information on troubleshooting deployment errors, refer to Troubleshoot common Azure deployment errors.

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Verify that the storage account you are using is accessible and configured correctly. This includes verifying that the account is in the same region as the managed instance or is accessible from the Azure region where you are deploying the instance.

Sometimes, Managed Instances require access to a storage account for backups, restores, or other configuration tasks.

If you have a specific storage account configured for backup or other tasks, double-check the access key and ensure it’s correct. You can find the access keys in the Azure Portal under the storage account’s Access keys section.

Also, verify that any Virtual Network (VNet) or firewall settings on the storage account allow access from the VNet where your Managed Instance resides.

If using private endpoints or network security groups, ensure that appropriate rules are in place to permit access.

If possible, delete any partial deployments and retry the deployment, especially after confirming that the storage account details are accessible and correct.