All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

Verifying if a connection to SQL Server is Encrypted

Verifying if a connection to SQL Server is Encrypted

  • Comments 1
  • Likes

If you do not have a network parser such as netmon and want to verify if the connection from the client to the SQL server is encrypted, the following query can be utilised:


SELECT encrypt_option
FROM sys.dm_exec_connections
WHERE session_id = @@SPID

-- Note: remove the WHERE clause to see all connections.

Comments
  • good tip.. without installing  network parser able to find  encryption status.

    MSDN KB article should have  listed this.. instead of pushing for  netowkr parser install...

    Thank you

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment