question

vikas-7775 avatar image
0 Votes"
vikas-7775 asked NileshKhot-7479 answered

I am not able to create Azure Synapse Workspace

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

azure-synapse-analytics
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @vikas-7775,

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

0 Votes 0 ·

Hi @vikas-7775,

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.

0 Votes 0 ·

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

0 Votes 0 ·
VaibhavChaudhari avatar image
5 Votes"
VaibhavChaudhari answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AbhishekKhard-2083 avatar image
1 Vote"
AbhishekKhard-2083 answered

Microsoft.SQL already registered in resource provider.

Still not able to create Azure synapse , quite frustrating

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NileshKhot-7479 avatar image
0 Votes"
NileshKhot-7479 answered

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

Thanks

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.