找不到版本"GeneralPurpose"的默认服务水平目标. [英] No default service level objective found of edition "GeneralPurpose"

问题描述

在Azure SQL中创建数据库时，在SSMS中出现此错误No default service level objective found of edition "GeneralPurpose"

I am getting this error No default service level objective found of edition "GeneralPurpose" in SSMS when creating database in Azure SQL

推荐答案

请从

Please download the latest SQL Server Management Studio version from here. Version 18.0 has many fixes related to Azure Managed Instances.

这是您当前正在使用的免费订阅的限制. "免费试用版订阅可以通过S3数据库提供Basic，Standard S0，最多100个eDTU Basic或Standard弹性池以及通过DW400数据仓库提供DW100".

It is a limitation of the free subscription you are using at this time. ""'Free Trial subscriptions can provision Basic, Standard S0 through S3 databases, up to 100 eDTU Basic or Standard elastic pools and DW100 through DW400 data warehouses"

您还可以尝试使用T-SQL创建数据库，如下所示.

You can also try to create the database using T-SQL as shown below.

CREATE DATABASE Testdb
( EDITION = 'Standard', SERVICE_OBJECTIVE = 'S3' );
GO

这篇关于找不到版本"GeneralPurpose"的默认服务水平目标.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！