Error Deploying Azure QuickStart API Builder: SQL Database Unavailable in any location

Question

Hi all,

I'm new to azure and am on the free trial and I have been trying to follow this guide to get started on APIs within Azure, https://learn.microsoft.com/en-us/azure/data-api-builder/quickstart-azure-sql. But once I get to deploying the static web app, step 6, I run into this error each time "Location 'East US' is not accepting creation of new Windows Azure SQL Database servers at this time". I have tried troubleshooting this by picking different regions to no success. I then deleted all my resource groups and databases and uninstalled microsoft.sql from resource providers as well as analytics, both ideas I had got from this thread, https://learn.microsoft.com/en-us/answers/questions/1360141/deploying-synapse-workspace-subscription-error?source=docs. I'm running out of ideas now so any suggestions to get around this.

Thanks,

Eddie

Answer 1

Hi @Christopher Ajayi,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

As I understand, you are facing an issue with resource availability in Azure regions.

Here are some troubleshooting steps that might help you resolve the issue.

• Sometimes specific regions may have service interruptions. Check the Azure Status page to see if there are any ongoing issues in the East US region.
• If you haven't already, try deploying your resources in a different region where SQL databases are available. Regions like West US or Central US might have better availability.
• Ensure that you haven't reached your resource quota for your subscription. You can check your quota in the Azure portal under "Subscriptions" and then "Usage + quotas".
• As a workaround, you can try creating the SQL Database server manually through the Azure portal. After creating it, you can then proceed with the rest of the tutorial steps.
• The Azure free trial has certain limitations, including the types of resources you can create and their availability. Check if your selected resource types are allowed in your subscription.
• Sometimes, the resource creation limit is temporary. Waiting for a short while and trying again can sometimes resolve the issue.

For more information, please refer to the below links:

https://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql&tabs=portal

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.