Can't create a new azure synapse analytics resource: No location is accepted for my subscription

Elena Kovacheska 20 Reputation points
2025-03-14T12:45:18.0133333+00:00

I keep on getting this error when i try to create an azure synapse analytics resource. I tried multiple different regions but still the same error. Maybe something is wrong with my subscription. This is the error message i get: {"code":"ValidationFailed","message":"Workspace request validation failed, check error details for more information","details":[{"code":"SqlServerRegionDoesNotAllowProvisioning","message":"Location 'westcentralus' is not accepting creation of new Windows Azure SQL Database servers for the subscription '4fbd8cc9-3f45-422d-a5cd-c81439b905b9' at this time."}]}

Before that I created successfully one azure synapse analytics resource for test purposes but deleted it.

Any ideas why this error occurs and how to solve this problem? Thank you.

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Answer accepted by question author
Ganesh Gurram 7,235 Reputation points Moderator
2025-03-14T13:44:32.68+00:00

Hi @Elena Kovacheska

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. Modify the provider

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.

Reference: https://learn.microsoft.com/en-us/answers/questions/1845864/im-unable-create-synapse-analytics-workspace

Similar issues: https://learn.microsoft.com/en-us/answers/questions/1360141/deploying-synapse-workspace-subscription-error

https://learn.microsoft.com/en-us/answers/questions/150016/i-am-not-able-to-create-azure-synapse-workspace

https://learn.microsoft.com/en-us/answers/questions/1664531/location-southindia-is-not-accepting-creation-of-n

For more details refer: 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.

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.