How to Verify if the SQL Server connection is encrypted?

How do you verify if the SQL Server connection you are using is encrypted or not?

There is a way without using a network parser like netmon and verifying the connection encryption from the client using a simple query.

The following query can be used:

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

-- remove WHERE clause to see all connections.

SPID can be found at the bottom of the SQL Server Management Studio of your connection: