Azure-docs: sql server create Deployment failed. Location 'West Europe' is not accepting creation of new Windows Azure SQL Database servers at this time.

[pheu]

I get the following error when trying to create sql server.

Deployment failed. Correlation ID: SomeIdHere. Location 'West Europe' is not accepting creation of new Windows Azure SQL Database servers at this time.

I followed the basic tute.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 00961883-36eb-f736-b906-73d4c35e69b0
• Version Independent ID: 3a2fd493-9682-eedf-fad1-571b9391cd46
• Content: Tutorial: ASP.NET Core with SQL Database - Azure App Service
• Content Source: articles/app-service/app-service-web-tutorial-dotnetcore-sqldb.md
• Service: app-service
• GitHub Login: @cephalin
• Microsoft Alias: cephalin

[Grace-MacJones-MSFT]

Hi @pheu, thanks for the feedback! We are currently investigating and will update you shortly.

[pheu]

@Grace-MacJones-MSFT. Thank you. I tried with many locations eventually I was able to create the server in "East US" location. Still I think it's unclear, since the "West Europe" is listed by az appservice list-locations --sku FREE.

[LarsWH]

My colleague, who is administering our Azure accounts, contacted Microsoft yesterday, and today I can create DB in “West Europe” again.

[Grace-MacJones-MSFT]

@pheu can you try again to create a new sql server? are you still getting that error?

[cephalin]

This error is no longer reproducible. #please-close

[arpanos]

The same error seems to be back again.

[pheu]

@pheu can you try again to create a new sql server? are you still getting that error?

@Grace-MacJones-MSFT I don't have the error when creating sql server anymore, but I have another one while trying to create an app service plan:

"This region has quota of 0 instances for your subscription. Try selecting different region or SKU."

[ssisjoost]

Make sure that you have added Microsoft.SQL as allowed resource in your subscription. I got that same error on a new subscription where it was not available by default http://microsoft-bitools.blogspot.com/2020/10/synapse-snack-no-new-azure-sql-database.html

[la-21]

Make sure that you have added Microsoft.SQL as allowed resource in your subscription. I got that same error on a new subscription where it was not available by default http://microsoft-bitools.blogspot.com/2020/10/synapse-snack-no-new-azure-sql-database.html

This worked for me. Both the Microsoft.Synapse and Microsoft.Sql needs to be registered first before you'll be able to create an Azure Synapse Analytics workspace. To do this, go to Subscriptions > Subscription name > Settings > Resource Providers, search then click the Provider name and _Register_.