ResourceDeploymentFailure

Anonymous
2023-07-13T11:55:51.3366667+00:00

Hi,

I am a complete novice at Microsoft Azure trying to make my first deployment using a Free Trial subscription.  I have successfully created a new server and created a database in that server. I got this error when I tried to import the bacpac file from the storage container.

"ResourceDeploymentFailed” The resource operation completed with terminal provisioning state 'Failed';

I wasn’t sure how to fix the error so I deleted the database – now I can’t create another one except I pay and I can’t also restore the deleted database.

Also,i got a paid subcription so i could create the database yet again got the same error message.

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

See full details below:

{"code":"DeploymentFailed","target":"/subscriptions/10d1094f-bc47-41cd-9b8a-b24b279e4c3b/resourceGroups/DefaultResourceGroup-SUK/providers/Microsoft.Resources/deployments/Microsoft.SQLDatabase.newDatabaseImportExistingServer_3dbfb595e8","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/10d1094f-bc47-41cd-9b8a-b24b279e4c3b/resourceGroups/DefaultResourceGroup-SUK/providers/Microsoft.Sql/servers/consolhq/databases/ConsolHQ/extensions/import-without-private-link","message":"The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'."}]}

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

Accepted answer
  1. RahulRandive 10,221 Reputation points
    2023-07-13T22:10:56.51+00:00

    Hi @Anonymous

    You can find the meaningful error in the Activity log of the server.

    Are you trying to import database using SQL AAD credential? Look like it is failing to while communicating with the SQL Server using AdPassword-login.

    Please try an operation using SQL Admin credentials.

    If you are using portal, under authentication type, select "SQL Server"/SQL Authentication and see if it works?

    User's image

    Let us know if it still fails and share correlation id or request id.

    Thank you.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. MOIN UDDIN ANSARI 0 Reputation points
    2024-01-10T09:17:48.7066667+00:00

    Hi,

    I m getting same issue, although i tried creating data base with different subscription and account still same error, and i also tried creating using postgres also same error occurs, and also tried with solution from above still same error:

    {"code":"DeploymentFailed","target":"/subscriptions/2ce6b445-489a-44db-bf4c-f8b55f426d05/resourceGroups/DefaultResourceGroup-EUS/providers/Microsoft.Resources/deployments/MySqlFlexibleServer_e723e436c4cd4ed58f16c741e02d9dde","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/2ce6b445-489a-44db-bf4c-f8b55f426d05/resourceGroups/DefaultResourceGroup-EUS/providers/Microsoft.DBforMySQL/flexibleServers/abbb","message":"The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'."}]}

    Please can anyone tell the latest options to fix this.
    Thank you

    0 comments No comments

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.