How to change MinimalTlsVersion on Synapse managed Sql Server

Gonzalo Yubero 0 Reputation points
2024-01-18T09:48:31+00:00

Hello, I currently have an Azure Synapse Analytics with a SQL Server that needs to have the Minimal TLS version set to 1.2 for compliance. The server is currently set to "None", and I am unable to change it from the portal. Is there a way for me to change it? Thank you.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,175 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. RahulRandive 10,221 Reputation points
    2024-01-18T20:43:10.78+00:00

    Hi @Gonzalo Yubero
    Here is document and command to update the version using PowerShell or CLI https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-settings?view=azuresql&tabs=azure-powershell#minimal-tls-version CLI # Get current setting for Minimal TLS Version az sql server show -n sql-server-name -g sql-server-group --query "minimalTlsVersion" # Update setting for Minimal TLS Version az sql server update -n sql-server-name -g sql-server-group --set minimalTlsVersion="1.2" The following PowerShell script shows how to Get and Set the Minimal TLS Version property at the logical server level: # Get the Minimal TLS Version property (Get-AzSqlServer -ServerName sql-server-name -ResourceGroupName sql-server-group).MinimalTlsVersion # Update Minimal TLS Version to 1.2 $SecureString = ConvertTo-SecureString "password" -AsPlainText -Force Set-AzSqlServer -ServerName sql-server-name -ResourceGroupName sql-server-group -SqlAdministratorPassword $SecureString -MinimalTlsVersion "1.2" Thank you!


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.