I am trying to create a new SQL database in Azure, which I have managed to do successfully using azurerm_mssql_server and azurerm_mssql_database. The DB is online, and I have been able to configure firewall and vnet policies to allow connections from specific networks in my subscription.
What I cant seem to work out how to do via Terraform though is fix the minimum TLS version to 1.2 and disable the ‘Allow Azure resources access to this database’ setting. These seem like pretty reasonable security features to turn on really, so I am hoping there is a way for me to do this? Documentation suggests this is possible for the likes of a mysql server, but not Microsoft SQL. Anyone tried this and had any success?