Azure Free Trial – SqlServerRegionDoesNotAllowProvisioning Error When Creating Azure Synapse Workspace

Valentine Chukwunwike 20 Reputation points
2026-10-23T16:09:31.6366667+00:00

Hello Microsoft Azure Support Team,

I am currently using an active Azure Free Trial subscription to set up an Azure Synapse Analytics workspace for Data Engineering training.

However, I have been unable to complete the deployment because of the following error:

Error Code: SqlServerRegionDoesNotAllowProvisioning

Error Message: Location is not accepting new SQL Database server creations.

Troubleshooting Steps Already Taken

  1. Attempted to deploy Azure Synapse Analytics in three different regions:
    • UK West (ukwest)
    • UK South (uksouth)
    • West Europe (westeurope)
    Verified that the Microsoft.Sql resource provider is registered. Confirmed that my Azure Free Trial subscription is active and enabled. Used Azure's troubleshooting diagnostics, which identified a likely subscription-level regional access restriction for Azure SQL provisioning. Checked Azure Service Health, which reported no active incidents affecting my subscription. Attempted to request assistance through Azure Help + Support but encountered limitations associated with my Free Trial subscription and Basic Support Plan.

Assistance Requested

I would appreciate guidance on the following:

Is Azure SQL server provisioning restricted for Azure Free Trial subscriptions in these regions?

Is there a supported region where I can successfully deploy an Azure Synapse Analytics workspace using my existing Free Trial subscription?

Can regional SQL provisioning access be enabled for my subscription without upgrading to Pay-As-You-Go?

If upgrading is necessary, will it resolve this restriction, and can I retain my remaining Free Trial credit?

My objective is to use Azure Synapse Analytics for learning and practical Data Engineering projects.

I would appreciate any guidance on resolving this issue while remaining within the limits of my Free Trial subscription.

Thank you for your assistance.Hello Microsoft Azure Support Team,

I am currently using an active Azure Free Trial subscription to set up an Azure Synapse Analytics workspace for Data Engineering training.

However, I have been unable to complete the deployment because of the following error:

Error Code: SqlServerRegionDoesNotAllowProvisioning

Error Message: Location is not accepting new SQL Database server creations.

Troubleshooting Steps Already Taken

Attempted to deploy Azure Synapse Analytics in three different regions:

UK West (ukwest)

  UK South (`uksouth`)
  
     West Europe (`westeurope`)
     
     Verified that the `Microsoft.Sql` resource provider is registered.
     
     Confirmed that my Azure Free Trial subscription is active and enabled.
     
     Used Azure's troubleshooting diagnostics, which identified a likely subscription-level regional access restriction for Azure SQL provisioning.
     
     Checked Azure Service Health, which reported no active incidents affecting my subscription.
     
     Attempted to request assistance through Azure Help + Support but encountered limitations associated with my Free Trial subscription and Basic Support Plan.

Assistance Requested

I would appreciate guidance on the following:

Is Azure SQL server provisioning restricted for Azure Free Trial subscriptions in these regions?

Is there a supported region where I can successfully deploy an Azure Synapse Analytics workspace using my existing Free Trial subscription?

Can regional SQL provisioning access be enabled for my subscription without upgrading to Pay-As-You-Go?

If upgrading is necessary, will it resolve this restriction, and can I retain my remaining Free Trial credit?

My objective is to use Azure Synapse Analytics for learning and practical Data Engineering projects.

I would appreciate any guidance on resolving this issue while remaining within the limits of my Free Trial subscription.

Thank you for your assistance.

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.

0 comments
Answer accepted by question author
Alex Burlachenko 26,695 Reputation points MVP Volunteer Moderator
2026-10-26T08:44:36.77+00:00

Hi Valentine Chukwunwike & thx for join me at Q&A platform,

error SqlServerRegionDoesNotAllowProvisioning is fairly specific. Your subscription is not currently permitted to create the Azure SQL logical server required by the Synapse workspace in the selected region.

This can happen with Free Trial subscriptions, but it doesn't necessarily mean Azure Synapse is completely unavailable to Free Trial users. Regional capacity controls and subscription-specific provisioning restrictions can both produce this error.

You've already checked three regions, confirmed that Microsoft.Sql is registered, and verified that your subscription is active. I wouldn't spend more time repeating those checks. Also, a healthy Azure Service Health status doesn't rule out regional provisioning restrictions.

Unfortunately, there's no reliable public list of regions guaranteed to accept new SQL logical servers for a particular Free Trial subscription. I wouldn't recommend another region as a confirmed solution without checking your subscription's actual provisioning access.

Microsoft's Azure SQL guidance provides a route for this exact error: request regional provisioning access through Help + support > New support request > Service and subscription limits (quotas). Specify Azure SQL Database, the affected subscription, and one of the regions you need. Explain that the SQL logical server dependency is preventing Synapse workspace creation.

These requests are different from ordinary technical support incidents, so having Basic Support doesn't automatically mean every subscription-limit request is unavailable. However, Microsoft still needs to determine whether an exception can be granted for your Free Trial subscription. There's no guarantee of approval.

Regarding upgrading to Pay-As-You-Go, it may remove the Free Trial restriction, and there are previous reports of Synapse deployments succeeding after upgrading. But upgrading doesn't guarantee access to a region with capacity restrictions, so I wouldn't treat it as a guaranteed fix.

The good news is that Microsoft allows you to retain your remaining Free Trial credit when upgrading within the initial 30-day period. The credit remains valid only until the original 30-day expiration date; upgrading doesn't restart that period. After the credit expires or is exhausted, billable resources can generate charges.

For a learning environment, I'd first attempt the regional access request before changing the subscription offer. If support confirms that provisioning cannot be enabled for your Free Trial, then upgrading becomes a more reasonable option.

Also, remember that Synapse isn't entirely free just because you're using Free Trial credits. Depending on the features you enable, Spark pools, dedicated SQL pools, and other resources can consume those credits fairly quickly. Set a budget alert and stop or delete unused resources.

The actual regional entitlement is controlled by Azure's provisioning backend, so nobody on Microsoft Q&A can reliably confirm or enable it without a support-side check.

rgds,

Alex

p.s. if my answer is help - pls mark it as an answer

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Newest
Most helpful Newest Oldest

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.