synapse analytics deployment error

Question

I'm using my student account which gives $100 creidt.

{"code":"ValidationFailed","message":"Workspace request validation failed, check error details for more information","details":[{"code":"SqlServerRegionDoesNotAllowProvisioning","message":"Location 'eastus' is not accepting creation of new Windows Azure SQL Database servers for the subscription 'a4fa0764-c1fa-46e9-9942-26febf93e14b' at this time."}]}

Answer 1

@Sahu, Hardeep - (hardeepsahu) 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.

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

Here is the deployment status after unregistered and register the Microsoft.SQL

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.

Answer 2

Thanks for posting your question in the Microsoft Q&A forum.

Choose a different region for your Azure Synapse Analytics workspace. Some recommended regions include: Central US ,West US ,West US 2 ,North Europe ,West Europe ,Southeast Asia ,Australia East.

When creating the workspace, ensure you select one of these supported regions instead of East US

If you still encounter issues, try creating the storage account separately first, as suggested in the previous answer. Make sure to disable public blob access to comply with any existing policies.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful