How to fix the following problem while deploying azyre synapse analytics

Question

I encountered the following error in deployement of new azure synpase anylytics workspace.
I have tried the unregistering and reregistering of the Mirosoft sql from resource providers but that solution is not working for me.
Any other solution?

Answer 1

Hi @Karan Tuteja ,

Here are a few steps you can try to resolve this capacity limitation:

1. Check Quota Limits: Ensure that your subscription hasn’t reached its quota limit for Azure SQL Database servers in the ‘eastus’ region. You can request an increase in the quota through the Azure portal if needed.
2. Try a Different Region: If ‘eastus’ is currently not accepting new SQL Database servers, consider deploying your Azure Synapse Analytics workspace in a region with available capacity.
3. File a Support Request: If you need to deploy specifically in ‘eastus’, you might need to file a support request with Microsoft to enable the region for your subscription. This can be done through the Azure portal by selecting “Help + support” and then “New support request”. Choose the issue type related to “Service and subscription limits (quotas)”.
4. Verify Resource Provider Registration: Double-check that the Microsoft.Sql resource provider is registered for your subscription. You can do this in the Azure portal under “Subscriptions” > “Resource providers”. **
   Reference:**
   https://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql&tabs=portal

---

If this answers your question, please click Accept Answer and Yes if this answer was helpful. Doing so would help other community members with similar issues identify the solution. I highly appreciate your contribution to the community.

Answer 2

@Karan Tuteja Thanks for the question and using MS Q&A platform.

Your subscription may not have access to create a server in the selected region if that region has not been enabled. To resolve this, file a support request to enable a specific region for your subscription.

Register with SQL RP

To deploy Azure SQL resources, register your subscription with the SQL resource provider (RP).

You can register your subscription using the Azure portal, the Azure CLI, or Azure PowerShell.

To register your subscription in the Azure portal, follow these steps:

1. Open the Azure portal and go to All Services.
2. Go to Subscriptions and select the subscription of interest.
3. On the Subscriptions page, select Resource providers under Settings.
4. Enter sql in the filter to bring up the SQL-related extensions.
5. Select Register, Re-register, or Unregister for the Microsoft.Sql provider, depending on your desired action.

Additional provisioning issues:

If you're still experiencing provisioning issues, please open a Region access request under the support topic of SQL Database and specify the DTU or vCores you want to consume on Azure SQL Database or Azure SQL Managed Instance.

Azure Program regions:

Azure Program offerings (Azure Pass, Imagine, Azure for Students, MPN, BizSpark, BizSpark Plus, Microsoft for Startups / Sponsorship Offers, Visual Studio Subscriptions / MSDN) have access to a limited set of regions.

If your subscription is part of an Azure Program offering, and you would like to request access to any of the following regions, please consider using an alternate region instead:

Australia Central, Australia Central 2, Australia SouthEast, Brazil SouthEast, Canada East, China East, China North, China North 2, France South, Germany North, Japan West, JIO India Central, JIO India West, Korea South, Norway West, South Africa West, South India, Switzerland West, UAE Central , UK West, US DoD Central, US DoD East, US Gov Arizona, US Gov Texas, West Central US, West India.

For more details, refer to Resolve capacity errors with Azure SQL Database or Azure SQL Managed Instance.

Hope this helps. Do let us know if you 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.