I am not able to create Azure Synapse Workspace

Question

I am not able to create Azure Synapse Workspace

vikas 6

While trying to create a workspace I am getting error. I tried to create using many different locations/regions but still no luck.
Can somebody help me with this ?

{"code":"DeploymentFailed","message":"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage details.","details":[{"code":"BadRequest","message":"{\r\n \"error\": {\r\n \"code\": \"ValidationFailed\",\r\n \"message\": \"Workspace request validation failed, check error details for more information\",\r\n \"details\": [\r\n {\r\n \"code\": \"SqlServerRegionDoesNotAllowProvisioning\",\r\n \"message\": \"Location '' is not accepting creation of new Windows Azure SQL Database servers at this time.\"\r\n }\r\n ]\r\n }\r\n}"}]}

HarithaMaddi-MSFT 10,156 Reputation points

2020-11-04T11:00:35.833+00:00
Hi @vikas ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

We have not received a response from you. Let us know for any further queries and if below answer from @Vaibhav Chaudhari is helpful.

---------------------------------------------------------------------------------------------------

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
HarithaMaddi-MSFT 10,156 Reputation points

2020-11-05T08:25:16.037+00:00

Hi @vikas ,

We still have not heard back from you. Following up to check if below answer is helpful. Kindly share for any further queries or if issue persists and we will be glad to assist.
Nilesh Khot 6 Reputation points

2022-03-25T10:05:04.987+00:00

I am facing same issue and resolution provided below to register 'SQL Database Server' isnt working for me too. Kindly help

5 answers

Your answer

HarithaMaddi-MSFT 10,156 Reputation points

2020-11-04T11:00:35.833+00:00

Hi @vikas ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

We have not received a response from you. Let us know for any further queries and if below answer from @Vaibhav Chaudhari is helpful.

---------------------------------------------------------------------------------------------------

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
HarithaMaddi-MSFT 10,156 Reputation points

2020-11-05T08:25:16.037+00:00

Hi @vikas ,

We still have not heard back from you. Following up to check if below answer is helpful. Kindly share for any further queries or if issue persists and we will be glad to assist.
Nilesh Khot 6 Reputation points

2022-03-25T10:05:04.987+00:00

I am facing same issue and resolution provided below to register 'SQL Database Server' isnt working for me too. Kindly help

Answer 1

Raghunathan P 0

"message": "Location '' is not accepting creation of new Windows Azure SQL Database servers at this time.

The error message code says bad request

As the error message also says "message": "Location '' is not accepting creation of new Windows Azure SQL Database servers at this time.

Try switching the location and try again. It should resolve

0 comments

Answer 2

Vipul Aggarwal 5

I will have to delete all SQL resources to deregister, it's absurd

kkmsftazurecert 0 Reputation points

2024-07-20T00:17:56.8433333+00:00

Totally agree and the error is meaningless

Answer 3

Nilesh Khot 6

I deregistered Microsoft SQL and registered again and then tried to create Synapse WS - it worked for me.

Thanks

kkmsftazurecert 0 Reputation points

2024-07-20T00:17:35.7966667+00:00

Thnx, it worked.

Answer 4

Abhishek Khard 11

Microsoft.SQL already registered in resource provider.

Still not able to create Azure synapse , quite frustrating

0 comments

Answer 5

Vaibhav Chaudhari 39,026 Volunteer Moderator

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

For reference - http://microsoft-bitools.blogspot.com/2020/10/synapse-snack-no-new-azure-sql-database.html

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

0 comments