synapse analytics deployment error

Question

synapse analytics deployment error

Sahu, Hardeep - (hardeepsahu) 20

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."}]}

Smaran Thoomu 35,870 Reputation points Microsoft External Staff Moderator

2024-07-31T15:36:08.3433333+00:00

@Sahu, Hardeep - (hardeepsahu) Just checking in to see if the below answer provided by @Anonymous helped.

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.

3 answers

Your answer

Smaran Thoomu 35,870 Reputation points Microsoft External Staff Moderator

2024-07-31T15:36:08.3433333+00:00

@Sahu, Hardeep - (hardeepsahu) Just checking in to see if the below answer provided by @Anonymous helped.

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 1

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

Answer 2

Smaran Thoomu 35,870 Microsoft External Staff Moderator

@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.

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.SQL User'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.

Sahu, Hardeep - (hardeepsahu) 20 Reputation points

2024-07-26T18:42:08.92+00:00

@Anonymous I have tried it, and also changed region to east US and central US. I'll again with some other region.
Smaran Thoomu 35,870 Reputation points Microsoft External Staff Moderator

2024-07-29T13:02:34.94+00:00

Sahu, Hardeep - (hardeepsahu) We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sahu, Hardeep - (hardeepsahu) 20 Reputation points

2024-07-29T23:19:33.9433333+00:00

It worked, but changed the region 2 or 3 times
Smaran Thoomu 35,870 Reputation points Microsoft External Staff Moderator

2024-07-30T04:24:59.1+00:00

Sahu, Hardeep - (hardeepsahu) Just checking in to see if the above answer helped. 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 3

Gabor Stefan 0

In my case I had to use the same region as the subscription, especially is you use Visual Studio 2022 free subscription.

0 comments