How to get my database deployment to work?

Ryan Tay 5 Reputation points
2025-01-01T19:01:33.6833333+00:00

This was the raw error that I got after trying to deploy my SQL database. I've tried to redeploy twice but got the same error.

{
  "code": "DeploymentFailed",
  "target": "/subscriptions/e799b9c2-dcfa-4ec0-a5b3-cbca39a8ca44/resourceGroups/adecco_resources/providers/Microsoft.Resources/deployments/Microsoft.SQLDatabase.newDatabaseExistingServer_04cbeeae9a344e9f",
  "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/e799b9c2-dcfa-4ec0-a5b3-cbca39a8ca44/resourceGroups/adecco_resources/providers/Microsoft.Sql/servers/adecco-db/databases/adecco_db",
      "message": "The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'."
    }
  ]
}
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
40,962 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.