SSL Encryption without Forced encrytpion - how to test

• jshurak

  SSCrazy

  Points: 2763

  More actions

  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?

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  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

• azad maratha

  Default port

  Points: 1468

  More actions

  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.