Azure SQL Server cannot create database

Question

I am trying to create a database in Azure SQL Server. However, when I try to create it, it prompts "Gen4 family is not available in this region" and cannot create the database. What is the problem?

Answer 1

I encountered this same error when trying to create the DB via the GUI menu. So I opened a query and entered CREATE DATABASE dbname and it worked without issue.

Strange since they both should have used the default options, there should really have been no difference.

Answer 2

As Vijay Rajendiran said, if the region where your Azure SQL server in is not support Gen4 price tier, then you could not create the database.

To solve the problem, I have two suggestions:

1. create the database with other price tier except Gen4 - General Purpose (GP_Gen4_1).

2. create the database with new SQL server, when we configure the database price tier, portal will show us if the price tier is supported.

Hope this helps.