Symptoms

You cannot connect to a server that is running Microsoft SQL Server 2014 or SQL Server 2012 by using the Transport Layer Security (TLS) protocol version 1.2. Additionally, the following error message is logged in the SQL Server error log:

TDSSNIClient initialization failed with error 0x80090331, status code 0x80. Reason: Unable to initialize SSL support. The client and server cannot communicate, because they do not possess a common algorithm.

Resolution

This problem was first fixed in the following cumulative update of SQL Server.

Cumulative Update 12 for SQL Server 2014 Cumulative Update 5 for SQL Server 2014 SP1 Cumulative Update 10 for SQL Server 2012 SP2 Cumulative Update 1 for SQL Server 2012 SP3Note This update adds the support for Transport Layer Security (TLS) protocol version 1.2 to SQL Server 2014 and to the Microsoft ODBC Driver for SQL Server.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

Note You can find information about the latest SQL Server builds from Where to find information about the latest SQL Server builds.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.