Error creating free Azure SQL Database for Spain region

Question

Hi,

I'm trying to create a new Azure SQL Database instance but I'm not able to do so because I'm receiving the following error message each time I try to create the database:

{"code":"ProvisioningDisabled","message":"Provisioning of free limit database is not supported for provided service level objective or region"}

I don't have any database created on that resource group and I can see the Apply offer button every time but each time I receive the same error message.

Answer 1

The error message you're seeing, "Provisioning of free limit database is not supported for provided service level objective or region", typically indicates that the free tier of Azure SQL Database is not available for the Spain region or the specific service tier you have selected. Here’s a breakdown of what could be causing the issue and possible steps to resolve it:

Possible Causes:

1. Free Tier Not Available in Spain Region: The free Azure SQL Database tier (often part of the Azure Free Account or Azure SQL Database free offer) may not be supported in all regions, including Spain. Each region has specific limitations for free services, and Spain may not be eligible for the free database offering at this time.
2. Incompatible Service Level Objective (SLO): The error could also indicate that the service level objective (SLO) you selected (e.g., DTUs, vCore-based) is not supported for the free tier. The free tier typically supports basic or entry-level options, so higher service levels might trigger this error.
3. Free Limit Already Exhausted: Even though you don’t see any existing databases in your resource group, it’s possible that you’ve already used up your free tier quota in another region or another subscription tied to your account. Azure limits the number of free databases you can create, and this might also apply globally, not just within a specific region.

Steps to Resolve:

1. Check the Available Regions for Free SQL Database:

• Verify if the free SQL Database offering is available in the Spain region. You can create the database in other regions where the free tier is supported (e.g., West Europe, North Europe).
  • If Spain is not available for the free tier, try selecting a different region when creating the SQL Database (e.g., West Europe).

2. Ensure the Correct Service Level Objective:

• Ensure that you’re selecting a Basic or Standard S0 performance tier, as the free tier typically only supports lower service levels. Higher tiers (e.g., Premium or vCore-based) are not supported for free database instances.
  • When creating the database, select Basic as the service level.

3. Check Your Free Service Usage:

• Check if you've exhausted your free tier limits in other resource groups, regions, or subscriptions. Even if you don't see a database in your current resource group, it might exist in another one or under a different subscription tied to your account.
  • Navigate to Cost Management + Billing in the Azure portal to see if the free offer is still available for your account.

4. Consider Paid Tiers:

• If the free tier is not available in the Spain region, you could either:
  • Choose a different region where the free tier is supported, or
  • Opt for a paid service tier if your project needs to stay in the Spain region.

Next Steps:

1. When creating the SQL Database, check if the "Free tier" or "Apply offer" button is available for other regions.
2. Select the Basic service level objective when provisioning the SQL Database.
3. If necessary, switch regions or consider a paid option if the Spain region doesn’t support the free tier.

If you need more help navigating the Azure portal or checking available tiers, let me know!

Answer 2

Hi @Wijan

It seems free offer is not yet available for Spain region. You may need to create database in other nearby region which is supported.

Please find below links to check the offer limitations https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer-faq?view=azuresql

Hope this help!

Thank You!