Finding Unencrypted SQL Server Connections, and the Instances That Accept Them
Use sys.dm_exec_connections to list SQL Server sessions that aren’t encrypted, check Force Encryption, and see how driver defaults changed.
Use sys.dm_exec_connections to list SQL Server sessions that aren’t encrypted, check Force Encryption, and see how driver defaults changed.