SQLAzure is not available for your selection of subscription and location

asked 2023-01-22T08:33:29.6833333+00:00
Gary Frewin 5 Reputation points

Hi Folks,

Trying to use Azure for the first time, I'm using a normal account (i.e not free tier or student) but it is just for a hobby project. I'm following the tutorial here in order to deploy my EFCore webapi project.

https://learn.microsoft.com/en-us/azure/app-service/tutorial-dotnetcore-sqldb-app

I'm on the page for Create WebApp + Database. I've slected my subscription and resource group and area UKSouth. When I select the database engine of SQLAzure, I get a the message in the topic name.

What is going on? I can select Postgres but I don't want or need that. I cannot select MySQL, and also, no matter what region I select the message is the same. It's also the same no matter whether I sleect basic or standard for the hosting plan.

I just want a simple web app with a sql database... what am I missing?

Thanks.

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
420 questions
Azure Web Apps
Azure Web Apps
A feature of Azure App Service used to create and deploy scalable, mission-critical web apps.
4,306 questions
Azure SQL Database
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
2,531 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. answered 2023-01-22T22:03:36.68+00:00
    Gary Frewin 5 Reputation points

    Thanks, for the answers. The subscription was one that had been upgraded from a free credit one. However, I created a brand new subscription and I'm still getting the same result:
    User's image

    EDIT:

    Oddly, I switched back to the original subscription after doing this, and it now seems to be working...

  2. answered 2023-01-22T19:14:22.7866667+00:00
    Sadik Tas 75 Reputation points

    Please send your configuration page as follows:A screenshot showing how to configure a new app and database in the Web App + Database wizard.

  3. answered 2023-01-22T19:40:44.6966667+00:00
    Alberto Morillo 24,631 Reputation points Microsoft MVP

    Maybe you created the new Azure subscription that enjoys a USD$250.00 free credit that later is upgraded to a pay-as-you-go subscription. In that scenario the error appears when you attempt to create an Azure SQL because of capacity issues on Azure.

    As a workaround, create another pay-as-you-go subscription in the same account and you will be able to create an Azure SQL database in the new subscription without any issues. After that you can delete the first subscription from your account, but you may lose the free credit associated with the first subscription.

  4. answered 2023-01-24T04:45:49.5733333+00:00
    Joshua Davies 1 Reputation point

    I am having the same issue. I have tried creating whole new accounts and am not yet able to fix the problem. I am creating pay-as-you-go accounts and attempting to create an app/database in Australia