CODEWITHSUNDEEP
azure-sql-databaseazureportal
Glen Little
Glen Little

Reputation: 7128

Error when creating new SQL Database in Azure SQL

When attempting to make a new Azure SQL database, it fails with this error:

No default edition found under server version "12.0" (Code: 45122)

This happens when choosing either a "Blank Database" or the "Sample" Database.

Is there a place that I can set a "default edition"?

Update

I suspect there may be a bigger issue. When attempting to provision a new Azure SQL Server, the only regions available are shown here, whereas SQL Database should be supported in all regions.

enter image description here

Upvotes: 3

Views: 2431

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15648

Alternatively, you can use Transact-SQL to create a database:

CREATE DATABASE hito   
COLLATE Japanese_Bushu_Kakusu_100_CS_AS_KS_WS   
( MAXSIZE = 500 MB, EDITION = 'standard', SERVICE_OBJECTIVE = 'S1' ) ;

Special Azure subscriptions may have limitations for creating databases on certain regions. East US is a region that does not have limitations for that type of subscriptions.

Upvotes: 3

Related Questions