Posted by Erland Sommarskog on 02/16/07 22:46

rsm (prakandapandit@yahoo.com) writes:
> We want to encrypt MS Sql Server data files - .mdf and .ldf with
> logged in user certificate and make sure that MS Sql Server service
> (running as Local System Account) can decrypt it.
>
> Is it possible to encrypt data files with a certificate that resides
> in logged in user's
> cert store and also MS SQL Server Service 'service account's cert
> store?

No.

If you are using SQL 2005, there are encryption routines builtin,
so that you encrypt some columns. Keep in mind that encrypting key
columns will have a very serious impact on performance.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]