I'm unable create Synapse analytics workspace

Question

Hi, this is Sudarshan Reddy working as Dataengineer in Oracle, India. Last week I choosen free trail plan on azure in order to enhance my skills with azure products.

However, when I'm trying to create Synapse workspace getting following error though I used to create it on several regions. So, can you please suggest which is the best region I can create Synapse analytics workspace. Also, let me know if you have any other suggestions. Thanks you.

Error message:
Location 'eastus' is not accepting creation of new Windows Azure SQL Database servers for the subscription '712f50ce-a820-45f9-9c6a-f84ae2beda48' at this time. (Code: SqlServerRegionDoesNotAllowProvisioning)

Best regards,

Sudarshan Reddy

Answer 1

@Sudarshan Reddy - Thanks for the question and using MS Q&A platform.

Your subscription may not have access to create a server in the selected region if that region has not been enabled. To resolve this, file a support request to enable a specific region for your subscription.

Register with SQL RP

To deploy Azure SQL resources, register your subscription with the SQL resource provider (RP).

You can register your subscription using the Azure portal, the Azure CLI, or Azure PowerShell.

To register your subscription in the Azure portal, follow these steps:

1. Open the Azure portal and go to All Services.
2. Go to Subscriptions and select the subscription of interest.
3. On the Subscriptions page, select Resource providers under Settings.
4. Enter sql in the filter to bring up the SQL-related extensions.
5. Select Register, Re-register, or Unregister for the Microsoft.Sql provider, depending on your desired action.

Additional provisioning issues:

If you're still experiencing provisioning issues, please open a Region access request under the support topic of SQL Database and specify the DTU or vCores you want to consume on Azure SQL Database or Azure SQL Managed Instance.

Azure Program regions:

Azure Program offerings (Azure Pass, Imagine, Azure for Students, MPN, BizSpark, BizSpark Plus, Microsoft for Startups / Sponsorship Offers, Visual Studio Subscriptions / MSDN) have access to a limited set of regions.

If your subscription is part of an Azure Program offering, and you would like to request access to any of the following regions, please consider using an alternate region instead:

Australia Central, Australia Central 2, Australia SouthEast, Brazil SouthEast, Canada East, China East, China North, China North 2, France South, Germany North, Japan West, JIO India Central, JIO India West, Korea South, Norway West, South Africa West, South India, Switzerland West, UAE Central , UK West, US DoD Central, US DoD East, US Gov Arizona, US Gov Texas, West Central US, West India.

For more details, refer to Resolve capacity errors with Azure SQL Database or Azure SQL Managed Instance.

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.