0

What is the latest TLS protocol (TLS 1.0 or TLS 1.1) to be used in SQL Server 2005? Also what ciphers are supported?

  • Welcome to DBA.SE. SQL Server 2005 is no longer supported. If you can add some context to your question explaining why you need to know about TLS support in SQL 2005, it might help us provide a more useful answer. – Doug Deden Mar 1 '19 at 20:06
1

(Note: extended support for SQL Server 2005 ended on April 12, 2016.)

From this Microsoft support page:

Will SQL Server 2005 be supported for TLS 1.2?

TLS 1.2 support is offered only for SQL Server 2008 and later versions.

From this SQL Protocols blog entry, for SQL 2000 and 2005:

The currently recognised protocols are, from highest to lowest: TLS1.1, TLS1.0, SSL3.0, SSL2.0.

and

[The] cipher suite to use is negotiated by SSL/TLS and depends upon the cipher suites supported by the OS on the client and the server.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.