Posted by Greg D. Moore \(Strider\) on 02/22/07 22:24

"rsm" <prakandapandit@yahoo.com> wrote in message
news:1172172849.993451.142190@t69g2000cwt.googlegroups.com...
> We are using SQL Server 2000.
>
> We are trying to provide an encryption solution for SQL Server
> database. ldf and mdf files are some thing we want to encrypt.
>
> Problem is that if we encrypt using user cert, we need to run SQL
> Server service as that user which works fine until user changes his
> password. In this case, we have to some how automatically change SQL
> Server service 'run as' user password. I was wondering if there is a
> way to install user cert as service cert so SQL Server can decrypt the
> ldf files on its own.
>


There is no built-in encryption in SQL 2000, so I'm 99% sure the answer is
no.

Simple answer; the user SQL Server runs under shouldn't be changing its
password often and when it does, should go through a normal change
procedure.

--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

[Back to original message]