Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 880
Glen Little Avatar asked May 18 '26 03:05

Glen Little


1 Answers

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.

like image 200
Alberto Morillo Avatar answered May 21 '26 20:05

Alberto Morillo



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!