SQL Server, R2, 2014 fully supports TLS1.2 encrypted transfer

SQL Server, R2, 2014 fully supports TLS1.2 encrypted transfer

Microsoft is pleased to announce that all major SQL Server client-driven and SQL Server distributions have supported transport Layer Security 1.2 for short, TLS 1.2.

Published on January 29, 2016, this release provides full support for SQL Server, SQL Server R2, SQL Server 2014 and SQL Server for TLS1.2.

Supported client drivers include: SQL Server Native Client, Microsoft ODBC Driver for SQL Server, Microsoft JDBC Driver for SQL Server, ADO (SqlClient).

For more information about SQL Server and client component updates, see the following KB3135244 article

https://support.microsoft.com/zh-cn/kb/3135244

Download KB3135244 patch to provide TLS 1.2 in the mainstream version of each server and client component

Client Components Server Components
SqlClient (. NET Framework 4.6) SQL Server 2014
SqlClient (. NET Framework 4.5.2, 4.5.1, 4.5) SQL Server 2012
SqlClient (. NET Framework 4.0) SQL Server R2
SqlClient (. NET Framework 3.5/a.k.a (. NET Framework 2.0 SP2) SQL Server 2008
MS ODBC Driver v11 (Windows)
SQL Server Native Client (for SQL Server & 2014)
SQL Server Native Client (for SQL Server R2)
SQL Server Native Client (for SQL Server 2008)
SQL Server Native clirnt (for SQL Server 2005)
JDBC 6.0
JDBC 4.2
JDBC 4.1

known issue : If you are using the CU update for SQL Server2014 and need TLS1.2 to encrypt the mirror, AlwaysOn availability Group, Service broker endpoint,

We recommend that you wait until the February 2016 SQL Server CU Update, which provides support for special scenarios. Also recommended you can view KB3135244 articles

After full support for TLS1.2 encrypted transport protocol, data transfer between client and server will be more secure

SQL Server, R2, 2014 fully supports TLS1.2 encrypted transfer