SQLTeam.com | Weblogs | Forums

How to find TLS 1.2 client connections in SQL


#1

Hi We applied TLS 1.2 SQL patch for our SQL 2008/2012/2014 servers and now we are planning to enable TLS 1.2 in the servers for client connections. Is there any way to find out what and number of connections (ODBC, SQL client, ) at SQL database level? So we update the client connections to use TLS 1.2. thanks.


#2

one way is

SELECT * FROM sys.dm_exec_connections