Post reply

SSL Encryption without Forced encrytpion - how to test

  • January 6, 2012 at 7:02 am

    #253005

    I've set up and instance to allow ssl connections as per this article:

    http://technet.microsoft.com/en-us/library/ms189067.aspx

    I've left the 'ForceEncryption' option set as 'no' due to logistical issues. (We need encryption from one source, but not necessarily other sources)

    I plan to set up a mock up SSIS job to test with the client's certificate with the option to 'force encryption protocol' then again without it. If the data will transmit under both conditions, I think I'm good from a client perspective.

    Is there any way to verify that the encryption is working though? Any way to verify that the data is encrypted?

  • January 9, 2012 at 9:10 am

    #1430573

    You can check for encrypted connections with this query:

    SELECT *

    FROM sys.dm_exec_connections

    WHERE encrypt_option = 'TRUE' ;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 24, 2012 at 1:48 am

    #1437499

    You can also monitor the data packets sent across the network with the help of Netmon tool. This tool is available at sysinternals site.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply