0

Are there updates to SQLSRV32.DLL driver to support TLS 1.2? Version 10.00.18362 seems to broker a successful #TLS 1.2 handshake to #SQLServer 2016

https://sqlvandalism.com/2017/03/22/what-client-provider-am-i-using-to-connect-to-sql-server/ (near the end)

1 Answer 1

1

SQLSRV32.DLL is the old SQL Server ODBC driver that's part of Windows.

In October 2020, Windows finally dusted off the source code for the built-in ODBC and OleDb SQL Server drivers and updated them to support TLS 1.2. See KB4580390.

3
  • Thank you David. Is is accurate to say that the SQLSRV32.DLL is no longer deprecated? Commented Dec 9, 2021 at 10:45
  • The changes announced in KB4580390 don't comment on data access protocol (sys.dm_exec_connections.protocol_version) and interface TDS protocol (sys.dm_exec_sessions.client_version). Using SQLSRV32.DLL to connect from a client, SQL Server 2016 reports these two values as "SQL Server 2000 SP1". Given KB4580390, are the reported values correct? Commented Dec 9, 2021 at 11:00
  • It was never technically deprecated. Just old. And it’s still a client from the SQL 2000 era. But it’s supported but not being actively enhanced. The new ODBC driver is still recommended. learn.microsoft.com/en-us/sql/connect/odbc/… Commented Dec 9, 2021 at 11:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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