cant create an azure sql database due to region issues

Question

ERROR VIEW

Resource '<DB-name>' 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: <DB name>)
+

i get error every time i try to choose a region to create the azure database sql or resource group , so that i have been never able to create a sql data base

Answer 1

Hi Seif Ismail,

The error message “RequestDisallowedByAzure” indicates that the resources you're trying to deploy are blocked due to a policy restricting the Azure regions where your subscription can create resources.

This usually happens when an Azure Policy such as “Allowed locations” or “Allowed resource deployment regions” is applied to ensure compliance and control over where resources can be deployed.

Verify:

1. In the Azure Portal, go to Policy > Assignments, and look for Allowed locations.
2. Open the policy assignment and check the Parameters tab to see the list of approved regions.
3. Make sure to create your resource group, virtual machine etc in one of these allowed regions.

If you want to use CLI:

az policy assignment list --query "[].{name:name,displayName:displayName,params:parameters}" -o tabl

If you need access to regions outside this list, you may need to contact Azure support for further assistance.

Reference: https://learn.microsoft.com/en-us/azure/azure-resource-manager/troubleshooting/error-policy-requestdisallowedbypolicy?tabs=azure-cli

Please find the documentation to raise support request:

https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request

Hope this helps! please let me know if you have any queries.