Gen4 family is not available in this region. Microsoft SQL Server, Error: 45122

This post describes how to fix the error 'Gen4 family is not available in this region. Microsoft SQL Server, Error: 45122'

Gen4 family is not available in this region. Microsoft SQL Server, Error: 45122

Cause

This error can occur when creating a new database in Azure using SQL Server Management Studio.

If you select the Configure SLO page, you will see GP_Gen4_1 as the Current Service Level Objective.  This setting is greyed out if you are not signed in to Microsoft Azure:

SQL Server Management Studio New Database Configure SLO not signed in

Resolution

When you are signed in, these Azure options can be changed.  I changed the Edition to Basic, which also changed the Current Service Level Objective to Basic:

SQL Server Management Studio New Database Configure SLO signed in

This enabled me to successfully create the database, however this may vary depending on your region.


Comments

Popular posts from this blog

LG TV This app will now restart to free up more memory

LG TV Clear All Browsing History Data

LG TV turn off Quick Start in settings