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

Post a Comment

Popular posts from this blog

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

-
Image
This post describes how to fix the error "This app will now restart to free up more memory" which can occur when using apps such as Netflix on an LG TV after just a few minutes of use. Resolution To resolve the issue, unplug the TV then press the on/off button for 10 seconds.  Wait a further 20 seconds then plug the TV back in and turn it back on. Apps should now run without the error. Edit: The on/off button on my LG TV is directly under the standby light on the bottom of the TV. Edit: I didn't have to do this myself but one person who has left a comment said that clearing all browsing data worked for them.  I have written a post explaining how to do this: LG TV Clear All Browsing History Data . Edit: A few other people have also suggested turning off quick start in settings (and if it's already off, turn it on then off again).  I have written a post explaining how to do this: LG TV turn off Quick Start in settings Related Posts -  LG TV delete/rem...
Read more

LG TV Clear All Browsing History Data

-
Image
This post describes how to clear all browsing history data from an LG TV. This is one way to resolve the error " This app will now restart to free up more memory " sometimes seen on LG TVs. Process The process to clear all browsing history data is as follows: 1. Press the Home button on the remote control and keep pressing right until you find the Web Browser then open it. 2. Scroll the wheel on the remote control to reveal the pointer on screen, then press the three dots stacked vertically (located in the top right of the screen, next to the close button) to open the Menu. 3. Select Settings from the Menu. 4. Scroll to the bottom of the Settings to reach the Clear Browsing Data section. 5. Press the Clear All Browsing Data button then press Yes to confirm. Related Posts -  LG TV turn off Quick Start in settings -  LG TV move or delete apps and shortcuts on home screen
Read more

Excel Import CSV not using "Use First Row as Headers"

-
Image
Issue When importing a CSV file into Microsoft Excel, you may find that it is not using "Use First Row as Headers" so you end up with Column1, Column2 etc as headers. Resolution To resolve this issue, press the Transform Data button in the bottom right. This loads the Power Query Editor which includes the "Use First Row as Headers" option in the Home ribbon.  Press this option once. Press Close & Load to apply. The first row is now being used as headers: Related Posts - Open a Microsoft Excel spreadsheet xlsx file as read only
Read more