I am trying to create Azure Synapse Analytics and its giving this error

Question

I am trying to create Azure Synapse Analytics and its giving this error

MD IRFAN 5

{"code":"ValidationFailed","message":"Workspace request validation failed, check error details for more information","details":[{"code":"SqlServerRegionDoesNotAllowProvisioning","message":"Location 'usgovvirginia' is not accepting creation of new Windows Azure SQL Database servers for the subscription '4c62f2ec-cd1e-4db3-89fe-81d100ac5343' at this time."}]}

0 comments

2 answers

Your answer

Answer 1

SqlServerRegionDoesNotAllowProvisioning means the selected region is currently not allowing creation of the Azure SQL server dependency required for a Synapse workspace for that subscription.

Try these steps:

In Azure portal, go to Subscriptions > select the subscription > Settings > Resource providers.
Verify these providers are registered:
- Microsoft.Synapse
- Microsoft.Sql
- If needed, also register: Microsoft.Network, Microsoft.Storage, Microsoft.ManagedIdentity, Microsoft.Compute, Microsoft.Authorization.
Retry the deployment in a different region.
If the region must be usgovvirginia and registration is already complete, open an Azure Support quota/capacity request for SQL Database / SQL Server for that region.

Also verify the Synapse prerequisites while creating the workspace:

The workspace needs an Azure Data Lake Storage Gen2 account.
The storage account used as primary storage must have hierarchical namespace enabled.
In the portal flow, if prompted that Microsoft.Synapse must be registered, register it from Subscriptions > Resource providers.

Answer 2

Hi @MD IRFAN ,

The error SqlServerRegionDoesNotAllowProvisioning indicates that the selected region usgovvirginia is currently not allowing Azure SQL logical server creation for your subscription, which is required for Synapse workspace deployment.

As an initial troubleshooting step, please verify that the Microsoft.Sql and Microsoft.Synapse resource providers are registered on the subscription. If they are already registered, try re-registering Microsoft.Sql and then attempt the deployment again.

Additionally, please try creating the Synapse workspace in a different supported Azure Government region and let us know the outcome. This will help determine whether the issue is specific to US Gov Virginia or affects the subscription more broadly.

References

Can't create a new Azure Synapse Analytics resource: No location is accepted for my subscription https://learn.microsoft.com/en-us/answers/questions/2225144/cant-create-a-new-azure-synapse-analytics-resource
I'm unable create Synapse analytics workspace https://learn.microsoft.com/en-us/answers/questions/1845864/im-unable-create-synapse-analytics-workspace
Azure resource providers and types - Azure Resource Manager https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/resource-providers-and-types
synapse analytics deployment error https://learn.microsoft.com/en-us/answers/questions/1841427/synapse-analytics-deployment-error
I am not able to create Azure Synapse Workspace https://learn.microsoft.com/en-us/answers/questions/150016/i-am-not-able-to-create-azure-synapse-workspace
Deploying Synapse Workspace Subscription Error https://learn.microsoft.com/en-us/answers/questions/2077598/deploying-synapse-workspace-subscription-error

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

SAI JAGADEESH KUDIPUDI 3,645 Reputation points Microsoft External Staff Moderator

2026-08-20T11:03:39.7366667+00:00

Hi @MD IRFAN ,
I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.