I am not able to create Azure Synapse Workspace

vikas 6 Reputation points
2020-11-03T16:20:46.75+00:00

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
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

5 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 39,026 Reputation points Volunteer Moderator
    2020-11-03T17:26:50.073+00:00

    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

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  2. Abhishek Khard 11 Reputation points
    2021-07-16T09:32:46.627+00:00

    Microsoft.SQL already registered in resource provider.

    Still not able to create Azure synapse , quite frustrating

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Nilesh Khot 6 Reputation points
    2022-03-25T10:25:52.757+00:00

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

    Thanks

    Was this answer helpful?

    1 person found this answer helpful.
  4. Vipul Aggarwal 5 Reputation points
    2023-04-04T00:22:08.6933333+00:00

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

    Was this answer helpful?

    1 person found this answer helpful.
  5. Raghunathan P 0 Reputation points
    2025-02-25T00:12:38.2233333+00:00

    "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

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.