I have setup ssl encryption for SQL connections by using a self-signed certificate (not the best I know) and setting "Force Encryption" to Yes. Now I am trying to show that the connection is indeed encrypted and I like to see which the ssl-key is used for a connection; preferably the one that I provided. How can I do this? I am just not comfortable trusting the OS or SQL to do what I ask.
The query "SELECT encrypt_option FROM sys.dm_exec_connections" Shows incrypted but no extra info.
Thanks
P.S. running W2008R2 + SQL2012 (patched).