Microsoft.Sql/servers/databases: The property "kind" is read-only

[L-Sypniewski]

Resource Type

Microsoft.Sql/servers/databases

Api Version

2023-02-01-preview

Issue Type

Property(s) inaccurately marked read-only/write-only

Other Notes

I was able to create a serverless Azure SQL DB by setting a kind to 'v12.0,user,vcore,serverless', but I'm getting a linter error The property "kind" is read-only

Bicep Repro

param appName string = 'azure-tests'
param location string

resource databaseServer 'Microsoft.Sql/servers@2023-02-01-preview' = {
  name: '${appName}-sqlserver'
  location: location
  properties: { administratorLogin: 'db_username'
    administratorLoginPassword: '<PASSWORD>' } }

resource database 'Microsoft.Sql/servers/databases@2023-02-01-preview' = {
  parent: databaseServer
  name: '${appName}-sqldb'
  location: location
  kind: 'v12.0,user,vcore,serverless'
  sku: {
    name: 'GP_S_Gen5'
    tier: 'GeneralPurpose'
    family: 'Gen5'
    capacity: 1
  }
  properties: {
    collation: 'SQL_Latin1_General_CP1_CI_AS'
    maxSizeBytes: 1073741824
    catalogCollation: 'SQL_Latin1_General_CP1_CI_AS'
    zoneRedundant: false
    readScale: 'Disabled'
    autoPauseDelay: 60
    requestedBackupStorageRedundancy: 'Geo'
    minCapacity: '0.5'
    isLedgerOn: false
    availabilityZone: 'NoPreference'
  }
}

Confirm

• [X] I have read the troubleshooting guide and looked for duplicates.

[microsoft-github-policy-service[bot]]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub. Please see https://aka.ms/biceptypesinfo for troubleshooting help.