Not able to create sql database

Hi **Amol Peshette,
** The behavior you are seeing is expected and is caused by an Azure Policy restriction applied to your subscription, specifically the“Allowed resource deployment regions”policy.

This policy enforces governance rules by restricting where resources can be deployed. In your case, only a specific set of regions are permitted. This means:

• You can create Azure SQL Server / Database only in the allowed regions defined in the policy
• Any attempt to deploy resources in a different region will fail during validation or deployment

This aligns with Azure Policy behavior, where deployments that do not comply with assigned policies are blocked (for example, with errors like RequestDisallowedByPolicy). The built-in “Allowed locations” policy specifically limits deployments to a defined list of regions and denies all others.

To resolve this issue, please follow these steps:

While creating the Azure SQL logical server, select one of the regions allowed by your policy. Then proceed with the database creation under that server.

If the issue was due to region restriction, deploying in one of the allowed regions should resolve it. No additional changes are required unless there are other policies or permission restrictions in your environment.

If you still encounter any error after selecting an allowed region, please share the exact error message so we can assist you further.

Microsoft Reference Links:

• Azure Policy overview and enforcement behavior:
  https://learn.microsoft.com/azure/governance/policy/overview
• Troubleshoot policy-related deployment errors (e.g., RequestDisallowedByPolicy):
  https://learn.microsoft.com/azure/governance/policy/troubleshoot/general
• Quickstart: Create an Azure SQL Database:
  https://learn.microsoft.com/azure/azure-sql/database/single-database-create-quickstart

Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.
Please do not forget to "Accept Answer" and "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.

Hi Amol,

What error message are you seeing when you attempt to create Azure SQL Logical Server? Are you trying via Azure portal, or CLI/PowerShell, or SSMS? If this is Azure for Students subscription, please see below.

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