|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Thursday, May 17, 2012 2:19 PM
Points: 108,
Visits: 485
|
|
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?
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Today @ 5:04 PM
Points: 3,499,
Visits: 5,590
|
|
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
Make everything as simple as possible, but not simpler. --Albert Einstein
We should be careful to get out of an experience only the wisdom that is in it - and stay there, lest we be like the cat that sits down on a hot stove
lid. She will never sit down on a hot stove lid again... but also, she will never sit down on a cold one any more. --Mark Twain
nanos gigantium humeris insidentes --Bernard of Chartres
How Standards Proliferate ~ Wisdom of the Ancients ~ Tradition ~ Forgot Algebra
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Yesterday @ 9:07 AM
Points: 273,
Visits: 333
|
|
| You can also monitor the data packets sent across the network with the help of Netmon tool. This tool is available at sysinternals site.
|
|
|
|
