API version change log for deployment of Microsoft.Sql/servers

This article describes the properties that changed in each API version for Microsoft.Sql/servers. It only covers properties that are available during deployments.

2023-05-01-preview

Updated:

• properties.minimalTlsVersion - Added values: '1.0' '1.1' '1.2' '1.3' 'None'
• properties.administrators.apiVersion - Added values: '2023-05-01-preview' - Removed values: '2023-02-01-preview'

2023-02-01-preview

Added:

• properties.isIPv6Enabled

Updated:

• properties.administrators.apiVersion - Added values: '2023-02-01-preview' - Removed values: '2022-11-01-preview'

2022-11-01-preview

Updated:

• properties.administrators.apiVersion - Added values: '2022-11-01-preview' - Removed values: '2022-08-01-preview'

2022-08-01-preview

Updated:

• properties.publicNetworkAccess - Added values: 'SecuredByPerimeter'
• properties.administrators.apiVersion - Added values: '2022-08-01-preview' - Removed values: '2022-05-01-preview'

2022-05-01-preview

Updated:

• properties.administrators.apiVersion - Added values: '2022-05-01-preview' - Removed values: '2022-02-01-preview'

2022-02-01-preview

Updated:

• properties.administrators.apiVersion - Added values: '2022-02-01-preview' - Removed values: '2021-11-01'

2021-11-01

Updated:

• properties.administrators.apiVersion - Added values: '2021-11-01' - Removed values: '2021-11-01-preview'

2021-11-01-preview

Updated:

• properties.administrators.apiVersion - Added values: '2021-11-01-preview' - Removed values: '2021-08-01-preview'

2021-08-01-preview

Updated:

• properties.administrators.apiVersion - Added values: '2021-08-01-preview' - Removed values: '2021-05-01-preview'

2021-05-01-preview

Updated:

• properties.administrators.apiVersion - Added values: '2021-05-01-preview' - Removed values: '2021-02-01-preview'

2021-02-01-preview

Added:

• properties.federatedClientId
• properties.restrictOutboundNetworkAccess

Updated:

• properties.administrators.apiVersion - Added values: '2021-02-01-preview' - Removed values: '2020-11-01-preview'

2020-11-01-preview

Added:

• identity.userAssignedIdentities
• identity.userAssignedIdentities.{customized property}
• properties.administrators
• properties.administrators.administratorType
• properties.administrators.azureADOnlyAuthentication
• properties.administrators.login
• properties.administrators.principalType
• properties.administrators.sid
• properties.administrators.tenantId
• properties.keyId
• properties.primaryUserAssignedIdentityId

Updated:

• properties.type - Removed values: 'Microsoft.Sql/servers'

2020-08-01-preview

Updated:

• properties.apiVersion - Added values: '2020-08-01-preview' - Removed values: '2020-02-02-preview'

2020-02-02-preview

Updated:

• properties.apiVersion - Added values: '2020-02-02-preview' - Removed values: '2019-06-01-preview'

2019-06-01-preview

Added:

• properties.minimalTlsVersion
• properties.publicNetworkAccess

Updated:

• properties.apiVersion - Added values: '2019-06-01-preview' - Removed values: '2015-05-01-preview'

2015-05-01-preview

Added:

• identity
• identity.type

Updated:

• properties.version - Removed values: '12.0' '2.0'
• properties.apiVersion - Added values: '2015-05-01-preview' - Removed values: '2014-04-01'

2014-04-01

Oldest version tracked in change log