Error while deploying - The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'

Question

Error while deploying - The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'

Saish Paradkar 25

Hello team. I get the error below when I deploy Azure Sql Managed Instance database to azure:
{0AE46D18-47AD-4FC6-8BF0-1D1DFF1041FC}

I had referred this link - https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-create-quickstart?view=azuresql&tabs=azure-portal
Error code - ResourceDeploymentFailure

Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator

2025-03-28T14:09:10.01+00:00

Hi Saish Paradkar,
Could you please response in the private chat , Thank you.
Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator

2025-03-31T16:34:04.9433333+00:00

Hi Saish Paradkar,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator

2025-04-01T17:02:32.4033333+00:00

Hi Saish Paradkar,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Saish Paradkar 25 Reputation points

2025-04-02T08:45:31.8466667+00:00

Hi Adithya, I have responded in the private chat. Thank you.
Saraswathi Devadula 13,495 Reputation points Microsoft External Staff Moderator

2025-04-04T12:55:49.8966667+00:00
Hi Saish Paradkar,

Following our discussion, you are unable to create the Managed Instance in Azure portal with below error message,
The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

We investigated and got to know that there might be a policy issue which is blocking to create the instance.

If you use Azure Policy to prevent resource creation or modification in a scope that includes a SQL Managed Instance subnet or virtual network, your policies must not prevent SQL Managed Instance from managing its internal resources. The following resources need to be excluded from policy deny effects for normal operation:

Resources of type Microsoft.Network/serviceEndpointPolicies, when resource name begins with \_e41f87a2\_

All resources of type Microsoft.Network/networkIntentPolicies

All resources of type Microsoft.Network/virtualNetworks/subnets/contextualServiceEndpointPolicies

Please do let us know if you have any further concerns. Thank you.
Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator

2025-04-07T16:34:23.4366667+00:00

Hi Saish Paradkar, We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer accepted by question author

0 additional answers

Your answer

Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator

2025-03-28T14:09:10.01+00:00

Hi Saish Paradkar,
Could you please response in the private chat , Thank you.
Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator

2025-03-31T16:34:04.9433333+00:00

Hi Saish Paradkar,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator

2025-04-01T17:02:32.4033333+00:00

Hi Saish Paradkar,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Saish Paradkar 25 Reputation points

2025-04-02T08:45:31.8466667+00:00

Hi Adithya, I have responded in the private chat. Thank you.
Saraswathi Devadula 13,495 Reputation points Microsoft External Staff Moderator

2025-04-04T12:55:49.8966667+00:00

Hi Saish Paradkar,

Following our discussion, you are unable to create the Managed Instance in Azure portal with below error message,
The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

We investigated and got to know that there might be a policy issue which is blocking to create the instance.

If you use Azure Policy to prevent resource creation or modification in a scope that includes a SQL Managed Instance subnet or virtual network, your policies must not prevent SQL Managed Instance from managing its internal resources. The following resources need to be excluded from policy deny effects for normal operation:

Resources of type Microsoft.Network/serviceEndpointPolicies, when resource name begins with \_e41f87a2\_

All resources of type Microsoft.Network/networkIntentPolicies

All resources of type Microsoft.Network/virtualNetworks/subnets/contextualServiceEndpointPolicies

Please do let us know if you have any further concerns. Thank you.
Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator

2025-04-07T16:34:23.4366667+00:00

Hi Saish Paradkar, We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi Saish Paradkar,

Following our discussion, you are unable to create the Managed Instance in Azure portal with below error message, The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

We investigated and got to know that there might be a policy issue which is blocking to create the instance.

In further investigation, got to know that the resource is missing with the policy.

{"code":"InvalidTemplateDeployment","message":"The template deployment failed with multiple errors. Please see details for more information.","details":[{"code":"RequestDisallowedByPolicy","target":"rg","message":"Resource 'rg' was disallowed by policy. Reasons: 'Missing TAG with Owner information. Please add a new Tag with Owner information as shown below:\n\nTag Name: Owner \nTag Value: [Email ID of Owner]'. See error details for policy resource IDs.","additionalInfo":[{"type":"PolicyViolation","info":{"evaluationDetails":{"evaluatedExpressions":[{"result":"True","expressionKind":"Field","expression":"tags[Owner]","path":"tags[Owner]","targetValue":"false","operator":"Exists"}],"reason":"Missing TAG with Owner information. Please add a new Tag with Owner information as shown below:\n\nTag Name: Owner \nTag Value: [Email ID of Owner]"},"policyDefinitionId":"/providers/Microsoft.Authorization/policyDefinitions/871b6d14-10aa-478d-b590-94f262ecfa99","policyDefinitionName":"871b6d14-10aa-478d-b590-94f262ecfa99","policyDefinitionDisplayName":"Require a tag on resources","policyDefinitionVersion":"1.0.1","policyDefinitionEffect":"deny","policyAssignmentId":"/providers/Microsoft.Management/managementGroups/PSL_Project_and_Delivery/providers/Microsoft.Authorization/policyAssignments/5b68a7ed2a844c1a8a19d9d1","policyAssignmentName":"5b68a7ed2a844c1a8a19d9d1","policyAssignmentDisplayName":"Require a tag on resources","policyAssignmentScope":"/providers/Microsoft.Management/managementGroups/PSL_Project_and_Delivery","policyAssignmentParameters":{"tagName":"Owner"},"policyExemptionIds":[],"policyEnrollmentIds":[]}}]}]}

Recommended you to try to delete the policy assignment and to create the SQL managed instance.

Successfully, managed instance is created.

Please refer the below document about the SQL MI,
User's image

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-powershell-prep%2Cazure-portal#overview

Saish Paradkar 25 Reputation points

2025-04-10T15:40:32.0933333+00:00

Thank you @Saraswathi Devadula for your help in fixing the Azure SQL Managed Instance deployment issue. Your support and quick troubleshooting made a big difference. Really appreciate it!

Share via

Error while deploying - The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'

0 additional answers

Your answer