Can we enable tls 1.0 on MSSQL Server 2019 on database level? if yes then how?

clip art of 
 a double-quote character

Question

i am running sql server 2019 on Linux box and trying to connect using a Windows server 2016 client, how can we enable TLS 1.0 for SQL Server 2019 on the Database/instance level.

TIA.

asked 2020-09-25 by Rafay Pervaiz


Answer

TLDR

You don’t.

Long answer

You should be using TLS 1.2. If you follow the documentation, you’ll be up and running using TLS, but you’ll be using TLS 1.2.

SQL Server 2019 does not support SSL/TLS1.0

answered 2020-09-25 by Andy Mallon