SQL database Deployment Issues

Question

SQL database Deployment Issues

Grant Anderson 0

Hello i'm trying to set up for a SQL server for my university class. I am one of the ones in my class that cannot get my server too deploy. When I set up my server I keep getting this error. I've been troubleshooting trying to fix the error for quite some time now. On my current subscription I only have access to a handful of regions, so i've tried switching too all my allowed regions and I'm still not having any luck. Thanks Screenshot 2026-09-09 at 4.50.18 PM.png

TP 163.1K Reputation points Volunteer Moderator

2026-09-09T21:36:45.0233333+00:00

Hi Grant,

Instead of trying to use Free offer, please try to create Azure SQL Database Basic, under DTU-based purchasing model in any of your five allowed regions. To do this, on Basics tab of Create SQL Database wizard, click on Configure database next to Compute + storage, for Service tier select Basic, click Apply.

Back on Basics tab, continue filling out required information, select Locally-redundant backup storage, finish wizard. If you select things correctly you should be able to get costs at about $5/month from your Azure for Students credit.

Basic provides only 5 DTUs, which isn't much power, but there is good chance it will be okay for your class. If you need more resources you could scale it up to higher tier like S0/S1 later.

Please reply back here with your results.

Thanks.

-TP

2 answers

Your answer

TP 163.1K Reputation points Volunteer Moderator

2026-09-09T21:36:45.0233333+00:00

Hi Grant,

Instead of trying to use Free offer, please try to create Azure SQL Database Basic, under DTU-based purchasing model in any of your five allowed regions. To do this, on Basics tab of Create SQL Database wizard, click on Configure database next to Compute + storage, for Service tier select Basic, click Apply.

Back on Basics tab, continue filling out required information, select Locally-redundant backup storage, finish wizard. If you select things correctly you should be able to get costs at about $5/month from your Azure for Students credit.

Basic provides only 5 DTUs, which isn't much power, but there is good chance it will be okay for your class. If you need more resources you could scale it up to higher tier like S0/S1 later.

Please reply back here with your results.

Thanks.

-TP

Answer 1

For Azure SQL Database, that error pattern usually maps to one of these subscription-level issues:

The subscription is not registered with the SQL resource provider (Microsoft.Sql)
The selected region is not enabled for SQL server creation on that subscription
The subscription has hit a regional quota or capacity limit

Since all allowed regions were already tried, the most direct path is:

In the Azure portal, go to All Services → Subscriptions.
Select the affected subscription.
Under Settings, open Resource providers.
Search for sql.
For Microsoft.Sql, select Register or Re-register.

If using CLI, run:

az provider register --namespace Microsoft.Sql

If using PowerShell, run:

Register-AzResourceProvider -ProviderNamespace Microsoft.Sql

After that, try creating the logical SQL server again.

If the same error continues, the documented resolution is to open a support request for region access / Service and subscription limits so the region can be enabled for the subscription. The documented errors for this include:

Your subscription does not have access to create a server in the selected region.
Provisioning is restricted in this region. Please choose a different region. For exceptions to this rule please open a support request with issue type of 'Service and subscription limits'
Location 'region name' is not accepting creation of new Windows Azure SQL Database servers for the subscription 'subscription id' at this time

If the issue is quota-related, the documented errors include:

Server quota limit has been reached for this location. Please select a different location with lower server count.
Could not perform the operation because server would exceed the allowed Database Throughput Unit quota of xx.

A similar resolved case showed deployment succeeding after region-level access was enabled for the subscription.

Answer 2

Deepesh Dhake 1,165

That error is the free-offer restriction, not a region issue. The simplest fix is to turn off "Apply free offer" on the Compute + storage blade, choose a small tier (Basic or minimal serverless General Purpose), and deploy.

0 comments