Posted by David Portas on 02/19/07 22:29

On 16 Feb, 04:16, "rsm" <prakandapan...@yahoo.com> wrote:
> Hi,
>
> 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. Assuming you are using SQL Server 2005 you should read the
encryption topics in Books Online.

It is in principle possible to encrypt every bit of user data in a
database, but I can't think of any good reasons for wanting to do that
- and there are many good reasons why NOT to do it. Could you explain
a bit more about your requirements.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]