Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Verify an Encrypted Connection via Monitor

Author  Topic 

Marketware
Starting Member

9 Posts

Posted - 2010-07-26 : 14:56:26
I want to use the .Encrypt option on the connection to encrypt my connection. I've run a query against the server to validate that the connection is encrypted, (see below) but I'd like the assurance that it really is encrypted.

So I've installed Microsoft Monitor v 3.4 and have it running, but frankly, its not really clear to me how I can tell if the connection is in fact encrypted.

Has anyone used Microsoft Monitor 3.4 and can tell me how to use this tool to verify that the connection data is being encrypted?

SELECT encrypt_option
FROM sys.dm_exec_connections
   

- Advertisement -