Encrypting MS SQL databases

Hi list !

I'm currently working on a solution needing to perform replications
between MS SQL Server databases: there will be a central database and
several laptops connecting to it. The replications will occur on the
laptops, so they will have all the data on them, including sensitive
data.

So I will need to encrypt the data in their databases, and AFAIK, MS SQL
server 2K does not have encryption tools included.

So I will be looking for a tool that:
- will not be a millstone around people's neck :) (having 5 more
logins/passwords to know just because of the encryption)
- will be strong enough to not panic if a laptop is stolen :)

Any clue will be appreciated !

---------------------------------------------------------------------------
This list is sponsored by: Norwich University

EARN A MASTER OF SCIENCE IN INFORMATION ASSURANCE - ONLINE
The NSA has designated Norwich University a center of Academic Excellence
in Information Security. Our program offers unparalleled Infosec management
education and the case study affords you unmatched consulting experience.
Using interactive e-Learning technology, you can earn this esteemed degree,
without disrupting your career or home life.

http://www.msia.norwich.edu/secfocus
---------------------------------------------------------------------------

Relevant Pages

  • Re: Encrypting MS SQL databases
    ... several laptops connecting to it. ... So I will need to encrypt the data in their databases, and AFAIK, MS SQL ... SIX STEPS TO SECURE SENSITIVE DATA IN MYSQL ...
    (Security-Basics)
  • Re: General Sanity Check on Programmatic Resetting of Links
    ... desktop PCs, but some of the managers may be on laptops. ... Lots of databases do this sort of thing. ... workgroup server at our main location. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Encrypting MS SQL databases
    ... An auto-synchronization has to be performed by the laptops when they are connected to one of our LANs. ... I doubt this can be perform automatically if the databases are encrypted:) ... SQL server 2K does not have encryption tools included. ... EARN A MASTER OF SCIENCE IN INFORMATION ASSURANCE - ONLINE The NSA has ...
    (Security-Basics)
  • Re: Database centralization architecture
    ... Is there anyway you could migrate all user databases from each branch ...     I get the following scenario in my hands: I have a datacenter placed at ... centralize all applications and databases, thus we need to bring all ... This would eliminate the need for replications down to or up from ...
    (microsoft.public.sqlserver.replication)
  • 3167 error - record is deleted in replicated database
    ... syncs on a LAN based replica which is located in the same building ... Recently have found two instances of databases that will no longer ... Anyone using replicated copies on laptops use a cluster on the ...
    (microsoft.public.access.replication)