The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

Question

• Resource/subscriptions/*****/providers/Microsoft.Sql/managedInstances/smi-inf-sql-dev-east1/securityAlertPolicies/Default
• Operation nameUpdate managed server threat detection policy
• Time stampThu May 04 2023 17:26:47 GMT-0400 (Eastern Daylight Time)
• Error codeResourceDeploymentFailure
• MessageThe resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

Answer 1

This error is not much use - I have found you're able to get more details by going to the Deployments tab in Azure, clicking on the failed deployment, Related Events, Expand the Operation, find the one that failed and then, this is the important bit, look at the Json tab. I've found that there is usually more added to the message than is shown further up the chain.

Answer 2

Please verify an Azure Policy may be preventing the deployment to succeed. Here you will find some built-in policies to start.