SQLAzure is not available for your selection of subscription and location

Question

Hey, beginner Azure user using "Create Web App + Database" to create a resource. Currently on the $200 free trial credits. I want to use SQLAzure for the database part of the resource but get the error message that "SQLAzure is not available for your selection of subscription and location".

Screenshot of the setup page below:

I have tried selecting other regions and database engines. Changing region doesn't make any difference. The only engine that works is PostgreSQL but I'm keen to use SQLAzure.

Any suggestions would be much appreciated!

Edit: someone posted a similar error message a few weeks ago but their solution was effectively "I waited and it fixed itself". Fine if that's the solution but was hoping for something more immediate :)

Answer 1

Hi @Hobly ,

That particular template uses a PremiumV2 SKU which may exceed what you can use on a free-tier. What you can do is instead of using Azure SQL with the Web App + Database use of the different SKUs like Postgres or MySQL. If you still want to use Azure SQL, create the web app and Azure SQL basic SKU with a maximum storage of 2GB.

You can use the following tutorial to properly configure your web app to use with your newly created Azure SQL instance.