Skip to content

Cant create Db with correct parameters. #13600

@OsaPL

Description

@OsaPL

The error contradicts with itself.
Powershell Win10 x64

Getting available:

>az sql db list-editions -l centralus -o table
ServiceObjective    Sku            Edition           Family    Capacity    Unit    Available
------------------  -------------  ----------------  --------  ----------  ------  -----------
Basic               Basic          Basic                       5           DTU     True

Creating server:

>az sql server create --name $authNameServer `
                     --admin-password 1337_Pass `
                     --admin-user hackerman `
                     --resource-group $resourceGroup `
                     --location centralus

And finally the Db:

>az sql db create --name $authNameDb `
                 --resource-group $resourceGroup `
                 --server $authNameServer `
                 --compute-model Serverless `
                 --capacity 5 `
                 --edition Basic `
                 --family None

az : Could not find sku in tier 'Basic' with family 'None', capacity 5. Supported families & capacities for 'Basic' are: [(None, 5)]. Please specify one of these supported combinations of family and capacity.
At line:15 char:1
+ az sql db create --name $authNameDb `
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (Could not find ...y and capacity.:String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError

Originally posted by @OsaPL in #11926 (comment)

Metadata

Metadata

Labels

SQLaz sqlService AttentionThis issue is responsible by Azure service team.customer-reportedIssues that are reported by GitHub users external to the Azure organization.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions