Deploying Synapse Workspace Subscription Error

Question

Deploying Synapse Workspace Subscription Error

Ryan Clark 0

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?

Chandra Boorla 11,565 Reputation points Microsoft External Staff

2023-09-07T12:40:51.08+00:00

Hi @Ryan Clark

Just checking in to see if the below 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.
Chandra Boorla 11,565 Reputation points Microsoft External Staff

2023-09-08T13:13:52.3333333+00:00

@Ryan Clark

We haven't heard anything from your side on the updates regarding issue resolution, do click Accept Answer and Yes for the survey 'Was the answer helpful'. Thankyou.

2 answers

Your answer

Chandra Boorla 11,565 Reputation points Microsoft External Staff

2023-09-07T12:40:51.08+00:00

Hi @Ryan Clark

Just checking in to see if the below 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.
Chandra Boorla 11,565 Reputation points Microsoft External Staff

2023-09-08T13:13:52.3333333+00:00

@Ryan Clark

We haven't heard anything from your side on the updates regarding issue resolution, do click Accept Answer and Yes for the survey 'Was the answer helpful'. Thankyou.

Answer 1

Chandra Boorla 11,565 Microsoft External Staff

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

PRADEEPCHEEKATLA 90,596 Reputation points

2023-09-11T04:22:46.97+00:00

@Ryan Clark - Following up to see if the above answer was helpful. 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.

Ryan Clark 0

Unfortunately, I still have the same issue. After trying this fix I'm still in the same spot:

Location 'centralus' is not accepting creation of new Windows Azure SQL Database servers for the subscription 'f66119a0-30e1-4ab2-93f9-d0017dcbbf05' at this time. (Code: SqlServerRegionDoesNotAllowProvisioning)

Chandra Boorla 11,565 Reputation points Microsoft External Staff

2023-09-12T11:54:58.6166667+00:00

@Chandra Boorla

Thank you for getting back to us.

When we attempted to use the CentralUS location for deployment of workspace, even we encountered the same error as it is not available at this location. However, when we tried using EastUS location, we were able to access it successfully.

Could you please try using EastUS location and inform us if you get the same error?

Looking forward for your response.
Chandra Boorla 11,565 Reputation points Microsoft External Staff

2023-09-13T12:38:44.6566667+00:00

Hi @Ryan Clark Following up to see if the above answer was helpful. 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

Karan Tuteja 45

Hey
I encountered the same issue. After going through the same steps, issue is still happening.
Any other solution?

Smaran Thoomu 22,030 Reputation points Microsoft External Staff

2024-08-05T01:02:38.6833333+00:00

@Karan Tuteja Since this thread is too old, I would recommend creating a new thread on the same forum with as much details about your issue as possible. That would make sure that your issue has better visibility in the community.

Share via

Deploying Synapse Workspace Subscription Error

2 answers

Your answer