How to fix this error while creating a SQL Database?

Question

{

"error": {

"code": "InvalidTemplateDeployment",

"details": [

  {

    "code": "RequestDisallowedByAzure",

    "target": "munazzahmaqsood-db",

    "message": "Resource 'munazzahmaqsood-db' was disallowed by Azure: This policy maintains a set of best available regions where your subscription can deploy resources. The objective of this policy is to ensure that your subscription has full access to Azure services with optimal performance. Should you need additional or different regions, contact support.."

  },

  {

    "code": "RequestDisallowedByAzure",

    "target": "EECS3421_DB_MunazzahMaqsood",

    "message": "Resource 'EECS3421_DB_MunazzahMaqsood' was disallowed by Azure: This policy maintains a set of best available regions where your subscription can deploy resources. The objective of this policy is to ensure that your subscription has full access to Azure services with optimal performance. Should you need additional or different regions, contact support.."

  }

],

"message": "The template deployment failed with multiple errors. Please see details for more information."

},

"details": {

"code": "InvalidTemplateDeployment",

"message": "The template deployment failed with multiple errors. Please see details for more information.",

"details": [

  {

    "code": "RequestDisallowedByAzure",

    "target": "munazzahmaqsood-db",

    "message": "Resource 'munazzahmaqsood-db' was disallowed by Azure: This policy maintains a set of best available regions where your subscription can deploy resources. The objective of this policy is to ensure that your subscription has full access to Azure services with optimal performance. Should you need additional or different regions, contact support.."

  },

  {

    "code": "RequestDisallowedByAzure",

    "target": "EECS3421_DB_MunazzahMaqsood",

    "message": "Resource 'EECS3421_DB_MunazzahMaqsood' was disallowed by Azure: This policy maintains a set of best available regions where your subscription can deploy resources. The objective of this policy is to ensure that your subscription has full access to Azure services with optimal performance. Should you need additional or different regions, contact support.."

  }

]

}

}

Answer 1

Hi,

Azure for Students restricts which regions you can deploy resources to. Typically you are restricted to five different regions, and these vary for each person.

Please navigate to Azure Policy -- Authoring -- Assignments using link below:

https://portal.azure.com/#view/Microsoft_Azure_Policy/PolicyMenuBlade/~/Assignments

Click on assignment named Allowed resource deployment regions

Examine Allowed locations Parameter value for list of regions, similar to below (regions in screenshot are different than yours):

The regions shown in your Parameter value are the ones you are allowed to deploy resources to. Please try to create resources in one of these regions and let me know the results.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Answer 2

The error you are encountering, RequestDisallowedByAzure, indicates that your subscription is restricted from deploying resources in the specified regions due to a policy that maintains a set of best available regions. To resolve this issue, you can take the following steps:

1. Review the Policy: Check the policies applied to your Azure subscription to understand the restrictions. This can usually be done through the Azure portal under the policy management section.
2. Contact Support: If you need to deploy resources in different regions that are currently disallowed, you should contact Azure support. They can assist you in enabling the necessary regions for your subscription.
3. Select Allowed Regions: If possible, modify your deployment to select regions that are allowed under your current subscription policy. This may involve changing the region in your deployment template or configuration.

By following these steps, you should be able to address the deployment error and successfully create your SQL Database.

---

References:

• Troubleshoot common Azure deployment errors
• Resolve policies