Unable to create sql server db

Question

Hello All,

When I'm trying to create a sql server db using a free acount it says "Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to aka.ms/sqlcapacity. Please try another region or create a support ticket to request access."

I tried on multiple regions but same issue.

Answer 1

Hi @Anil Kumar Pant,

Thank you for reaching out to Microsoft Q&A with your query.

Please follow the steps mentioned in this document https://learn.microsoft.com/en-us/azure/azure-sql/database/quota-increase-request?view=azuresql to create a request to allot your quota in the region you are trying to deploy the server.

Please let us know if you've further questions or if you're unable to create the request

Thank you!

Answer 2

Try to create the database using Azure CLI; sometimes this can work when the portal is having issues. by following the command below:

az sql db create --resource-group <your-resource-group> --server <your-sql-server-name> --name <your-database-name> --service-objective S0

If this doesn't work, then go to the Azure Portal and find the Help + Support section. There, you can create a support request to ask for more capacity in your free-tier subscription .Make sure your subscription is still active.

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards