Enabling TLS1.2 Support on SQL Server 2016

Question

Hi,

I have a server running W2012 R2 and SQL 2016 Express...

How do I enable the usage of TLS1.2 on the SQL server?
Every how to points to: https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server
But SQL server 2016 is not mentioned in the article

Regards
Thomas

Answer 1

>How do I enable the usage of TLS1.2 on the SQL server?

For SQL Server 2016 and later, support for TLS 1.1/1.2 is already enabled by default.

>But SQL server 2016 is not mentioned in the article

That's because the article only describes hotfixes required for older versions of SQL Server to support TLS 1.1/1.2. SQL Server 2016 already supports TLS 1.1/1.2 by default.

HTH,

---

Phil Streiff, MCDBA, MCITP, MCSA

Answer 2

Hi TLiebald,

As mentioned in https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server, "SQL Server 2016 and SQL Server 2017 on Windows versions ship with TLS 1.0 to TLS 1.2 support. You have to disable TLS 1.0 and 1.1 if you want to use only TLS 1.2 for client-server communication."

On Windows 8 and later versions of the client operating systems or Windows Server 2012 server and later versions of the server operating systems, TLS 1.2 should already be enabled.

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

Hi all,

yes, in SQL 2016 it (TLS1.2) is enabled. It's working. It was my fault :-)
I was installing a sw package and this package always showed a warning about TLS1.2 was not enabled.
This warning was a false warning and I have blindly trusted this message :-(

Regards and thanks for the fast reaction!
Thomas