SQL Server & SQL DB Move Validation Failed Across Subscription in Azure

Question

Hi, I am trying to move the SQL server and databases below but getting a validation error. Here is the snap of the error that I am getting:

Error Details:

{"message":"Resource move policy validation failed. Please see details. Diagnostic information: subscription id '1509071e-020d-4b2e-a3b0-446b5b3fb43e', request correlation id 'b038197c-a52e-46f9-9143-4818914a3ec9'. (Code: ResourceMovePolicyValidationFailed) Resource 'mazsqlpvtai02' was disallowed by policy. Reasons: 'Public network access must be disabled for PaaS services.'. See error details for policy resource IDs. (Code: RequestDisallowedByPolicy, Target: mazsqlpvtai02) Resource 'mazsqlmakai' was disallowed by policy. Reasons: 'Public network access must be disabled for PaaS services.'. See error details for policy resource IDs. (Code: RequestDisallowedByPolicy, Target: mazsqlmakai)","code":"ResourceMovePolicyValidationFailed","name":"efe7ff50-f4a2-4297-acb2-c190a8dde03a","status":409}

Can anyone tell me how to solve this error?

Thanks in Advance.

Answer 1

Hi, @Dheeman Das Thanks for posting your question in the Microsoft Q&A forum.

It seems like you are trying to move your SQL server and databases across subscriptions in Azure, but you are getting a validation error. The error message indicates that the move policy validation failed due to public network access being enabled for PaaS services. have you tried disabling the public network access and try.

Here is the documentation you can follow.

https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/move-resource-group-and-subscription#move-resources-to-a-new-resource-group-or-subscription

Regards

Geetha