Azure Synapse Workspace deployment fails due to Location 'westeurope' is not accepting creation of new Windows Azure SQL Database servers for the subscription

Question

I am attempting to provision an Azure Synapse Workspace, but the deployment consistently fails with the following error:

{"code":"ValidationFailed","message":"Workspace request validation failed, check error details for more information","details":[{"code":"SqlServerRegionDoesNotAllowProvisioning","message":"Location 'westeurope' is not accepting creation of new Windows Azure SQL Database servers for the subscription '####' at this time."}]}

I have confirmed that both the Synapse and SQL resource providers are registered within the subscription.

As a precautionary measure, I attempted to unregister and re-register these resource providers; however, the issue persists.

Answer 1

Hi @Teyfik Aksoy The error you're encountering indicates that the 'westeurope' region is currently not accepting the creation of new Azure SQL Database servers for your subscription. This can happen due to regional capacity limits or subscription-specific restrictions.

To address this issue, consider the following steps:

• Deploy to another region if possible, where Azure Synapse is available.
• Check Azure Service Health for any ongoing issues in 'westeurope': Azure Status.
• Verify resource provider registration for Microsoft.Synapse and Microsoft.Sql.
• Check your subscription quotas and request an increase if needed.
• Contact Azure Support if you must deploy in 'westeurope' and require assistance with capacity.

For more detailed information refer to the 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 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.