Post reply

DTS Encryption

  • September 13, 2006 at 6:53 am

    #62713

    Does DTS by default encrypt data while moving between different data sources? Is there a way to do that using 3rd party tools?

    TIA

  • September 13, 2006 at 12:05 pm

    #660188

    I vaguely remember tryign to trouble shoot a problem I was having with a DTS package and watching the traffic with ethereal and actually seeing the first row of data and then watching the Rollback happen, so I'd imagine probably not. 

    Depending on what you are trying to prevent, could you create a VPN between your SQL server and your remove Datasource to pass the data through.  That should at least help with problems from packet sniffers like ethereal and the like.  You may be able to accomplish the same thing with IPSec policies and such. 

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • September 13, 2006 at 12:52 pm

    #660206

    Thanks Luke.

    There is an option Use Encryption for Data on the connection properties. Do you / anyone know what that is for? Right click on SQL Server connection and click the advanced button.

    TIA

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

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