Hi

I am sending data across the internet from one SQL Server to another
using DTS (using a Tranform Data Task).

1. Is it possible to encrypt the data sent ?
2. Is it still possible if it sends it from an access database to SQL
Server ?

I am using SQL Server 2000

Thanks,
Craig

Craig,

Although I've never used any, there are numerous third-party tools designed
to encrypt data in Sql Server. How the software works and whether or not
encrypted data from one server can be sent and decrypted on a different
server can be done, I have no idea. I've been told the easiest to work with
and great solution is DBEncrypt from Application Security Inc.

You also have the option of encrypting data from router to router, but that
is a very costly scenario to implement, at least on Cisco platforms.

HTH,

Raymond Lewallen

"Craig HB" <craighb (AT) bigfoot (DOT) com> wrote