Hi, I have an issue trying to choose the minimal TLS version for my Azure SQL server. Everytime I try to deploy this template without this parameter it works and when I deploy it with this parameter it fails. I was wondering if anyone knows why and how can still implement this in the template below.
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"serverName": {
"defaultValue": "[uniqueString('sql', resourceGroup().id)]",
"type": "string",
"metadata": {
"description": "The name of the SQL logical server."
}
},
"location": {
"defaultValue": "[resourceGroup().location]",
"type": "string",
"metadata": {
"description": "Location for all resources."
}
},
"administratorLogin": {
"type": "string",
"metadata": {
"description": "The administrator username of the SQL logical server."
}
},
"administratorLoginPassword": {
"type": "securestring",
"metadata": {
"description": "The administrator password of the SQL logical server."
}
},
"AAD Admin Login": {
"type": "string",
"defaultValue": "",
"metadata": {
"description": "Emailaddress of the Azure Active Directory administrator."
}
},
"AAD Admin ObjectID": {
"type": "string",
"defaultValue": "",
"metadata": {
"description": "SID (object ID) of the server administrator."
}
},
"AAD TenantId": {
"type": "string",
"defaultValue": "[subscription().tenantId]",
"metadata": {
"description": "Tenant ID of the administrator."
}
},
"minimalTlsVersion":{
"type": "string",
"defaultValue": "1.2",
"allowedValues": [
"1.0",
"1.1",
"1.2"
],
"metadata": {
"description": "Minimal TLS version. Allowed values: '1.0', '1.1', '1.2'."
}
},
"sqlDBName": {
"type": "string",
"defaultValue": "",
"metadata": {
"description": "The name of the SQL Database."
}
},
"tier": {
"type": "string",
"defaultValue": "GeneralPurpose",
"metadata": {
"description": "The tier or edition of the particular SKU, e.g. Basic, Premium."
}
},
"skuName": {
"type": "string",
"defaultValue": "GP_Gen5_2",
"metadata": {
"description": "The database SKU."
}
},
"catalogCollation":{
"type": "string",
"defaultValue": "SQL_Latin1_General_CP1_CI_AS",
"allowedValues": [
"SQL_Latin1_General_CP1_CI_AS",
"DATABASE_DEFAULT"
],
"metadata": {
"description": "Collation of the metadata catalog."
}
},
"licenseType":{
"type": "string",
"defaultValue": "LicenseIncluded",
"allowedValues": [
"LicenseIncluded",
"BasePrice"
],
"metadata": {
"description": "The license type to apply for this database. LicenseIncluded if you need a license, or BasePrice if you have a license and are eligible for the Azure Hybrid Benefit."
}
},
"highAvailabilityReplicaCount":{
"type": "int",
"defaultValue": 0,
"metadata": {
"description": "The number of secondary replicas associated with the database that are used to provide high availability."
}
},
"requestedBackupStorageRedundancy":{
"type": "string",
"defaultValue": "Local",
"allowedValues": [
"Local",
"Zone"
],
"metadata": {
"description": "The storage account type to be used to store backups for this database."
}
},
"zoneRedundant": {
"type": "bool",
"defaultValue": "false",
"metadata": {"description": "Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones."
}
}
},
"resources": [
{
"type": "Microsoft.Sql/servers",
"apiVersion": "2014-04-01",
"name": "[parameters('serverName')]",
"location": "[parameters('location')]",
"properties": {
"administratorLogin": "[parameters('administratorLogin')]",
"administratorLoginPassword": "[parameters('administratorLoginPassword')]",
"minimalTlsVersion": "[parameters('minimalTlsVersion')]"
},
"resources": [
{
"type": "administrators",
"apiVersion": "2014-04-01",
"name": "activeDirectory",
"location": "[parameters('Location')]",
"dependsOn": [
"[concat('Microsoft.Sql/servers/', parameters('serverName'))]"
],
"properties": {
"administratorType": "ActiveDirectory",
"login": "[parameters('AAD Admin Login')]",
"sid": "[parameters('AAD Admin ObjectID')]",
"tenantId": "[parameters('AAD TenantID')]"
}
}
]
},
{
"type": "Microsoft.Sql/servers/databases",
"apiVersion": "2017-03-01-preview",
"name": "[format('{0}/{1}', parameters('serverName'), parameters('sqlDBName'))]",
"location": "[parameters('location')]",
"dependsOn": [
"[resourceId('Microsoft.Sql/servers', parameters('serverName'))]"
],
"sku": {
"name": "Standard",
"tier": "Standard"
},
"properties": {
"catalogCollation": "[parameters('catalogCollation')]",
"highAvailabilityReplicaCount": "[parameters('highAvailabilityReplicaCount')]",
"licenseType": "[parameters('licenseType')]",
"requestedBackupStorageRedundancy": "[parameters('requestedBackupStorageRedundancy')]",
"zoneRedundant": "[parameters('zoneRedundant')]"
}
}
]
}