Re: SQL Server Security Question

SQL Server 2005 can encrypt data. EFS can encrypt files. It is possible,
with SQL 2005, to encrypt data without the DBA being able to decrypt it. In
that case, you have to use symmetric keys.


Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Alex" <alim@xxxxxxxxxx> wrote in message

One of my clients is looking for a encryption tool for SQL Server to make
data, data files and backup files unavailable to unauthorized users AND
DBAs. DBAs should still be able to perform administrative tasks but not
query the data. Their current environment is SQL Server 2000 SP4 on Windows
2003 SP1 and upgrade to SQL 2005 is possible.

Is there such a tool and if so, do you have any recommendations?