Deploying Synapse Workspace Subscription Error

Ryan Clark 0 Reputation points
2023-09-05T15:41:52.5466667+00:00

I am having difficulties getting my workspace to deploy. I am using the free trial subscription on my Azure Portal in effort to practice using the various tools in preparation for the DP-500. When I move forward to deploy my workspace I get the following Error:

{"code":"ValidationFailed","message":"Workspace request validation failed, check error details for more information","details":[{"code":"SqlServerRegionDoesNotAllowProvisioning","message":"Location 'centralus' is not accepting creation of new Windows Azure SQL Database servers for the subscription 'f66119a0-30e1-4ab2-93f9-d0017dcbbf05' at this time."}]}

I have tried using different locations and made sure I have registered the proper resource groups. Am I not able to do this with the trial subscription? What should I do?

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.
4,316 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Chandra Boorla 75 Reputation points Microsoft Vendor
    2023-09-06T12:20:16.62+00:00

    @Ryan Clark - Welcome to Microsoft Q&A platform and thanks for posting your question.

    The error message you are seeing indicates that the location centralus is not accepting the creation of new Windows Azure SQL Database servers for your subscription at this time. This error message can occur when the region you are trying to deploy to has reached its capacity limit for the service you are trying to use.

    As per the repro from our end, I was tested the above scenario on our Azure free trial subscription, initially I was experiencing the above issue and I'm able to solve the problem with the below steps.

    To resolve this issue, you may follow the below steps:

    Step1: Open your subscription => Resource providers => Register Microsoft.SQL if it is not registered. 

    When I tried for the first time, I was experiencing the same issue as described above.

    User's image

    Step2: If it is registered, try to unregister and register again.

    Here is the deployment status after unregistered and register the Microsoft.SQLUser's image

    For more details, refer to Azure Portal - Register resource provider.

    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.