Set SQL Server connections to TLSv1.0

[Leandro Barbosa]

Greetings

How to set the database connection encryption to   TLSv1.0  instead of  TLSv1.2.

Thanks

Leandro and Lucas

[Pierre-Yves Blain]

It is not possible to set the the TLS version for the database, as it uses the latest and most secure version. It is not recommended to downgrade security to 1.0, and if clients are still using this version it would be best to upgrade them. This is recommended by Microsoft for SQL Server [1].

If you have and outdated application that doesn't support a version of TLS that is compatible with SQL Server, you can always use the Cloud SQL proxy [2] to encrypt connections.

[1] https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server

[2] https://cloud.google.com/sql/docs/sqlserver/sql-proxy