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:
