Share via

Unable to deploy an azure synapse workspace

Alonzo Barnett 0 Reputation points
2026-03-16T07:13:17.6+00:00

Deployments fail with the below error. I am also unable to deploy from the azure portal. In addition when I try to check the portal to deploy an Azure SQL Server, the page does not have any create option.

I have checked that both the Synapse and SQL service providers are registered.

synapse.WorkspacesClient#CreateOrUpdate: Failure sending request: StatusCode=400 -- Original Error: Code="ValidationFailed" Message="Workspace request validation failed, check error details for more information" Details=[{"code":"SqlServerRegionDoesNotAllowProvisioning","message":"Location 'eastus2' is not accepting creation of new Windows Azure SQL Database servers for the subscription...

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.

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yutaka_K_JP 1,655 Reputation points
    2026-03-19T11:08:45.9033333+00:00

    I think that… eastus2 just won’t mint a SQL srv for ur sub anymore, so the only clean path I’ve used is binding Synapse to an existng SQL srv or hopping to a region that still allows one — and if it deploys, peek the fw/vnet early, that’s the next snag.

    0 comments
  2. SAI JAGADEESH KUDIPUDI 2,210 Reputation points Microsoft External Staff Moderator
    2026-03-16T09:13:44.6633333+00:00

    Hi Alonzo Barnett,
    The error SqlServerRegionDoesNotAllowProvisioning indicates that the selected region (eastus2) is currently not allowing new Azure SQL Server provisioning for your subscription. Since an Azure Synapse workspace depends on an underlying Azure SQL logical server, the deployment fails during validation.

    This behavior is typically due to regional capacity constraints or subscription limitations, and not due to configuration issues.

    To resolve the issue, please follow the below steps:

    • Deploy in a different region (Recommended) Try creating the Synapse workspace in another supported region (e.g., Central India, West Europe, West US), where SQL server provisioning is allowed.
    • Check subscription type and quotas Ensure your subscription is not restricted (Free/Trial subscriptions may have regional limitations). Verify quotas from: Azure Portal → Subscription → Usage + quotas
    • Upgrade subscription (if applicable) Upgrade to Pay-As-You-Go to remove potential region restrictions.
    • Check Azure Service Health Validate if there are any ongoing capacity or service issues in the selected region.

    This issue is caused by region-specific provisioning restrictions. To unblock deployment and meet the expected outcome, it is recommended to use an alternate region or upgrade the subscription,
    Reference Link:
    https://dotnet.territoriali.olinfo.it/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql&tabs=portal https://azure.status.microsoft/en-us/status/history/

    Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.

    Please do not forget to "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.

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.