Re: securing mdf files

From: Stefan Berglund (keepit_at_in.thegroups)
Date: 06/22/05


Date: Wed, 22 Jun 2005 09:13:08 -0700

On Wed, 22 Jun 2005 20:40:06 +0530, "Hari Prasad"
<hari_prasad_k@hotmail.com> wrote:
 in <OJpPCxzdFHA.3712@TK2MSFTNGP12.phx.gbl>

>
>Hi,
>
>
>You can use the Encrypted File System Support on Windows 2000 .
>
>
>Windows 2000 support encrypted file system property.
>
>
>Below are the steps encrypt the data files:
>
>
>1) Logon with the SQL Server startup account
>
>
>2) Stop SQL Server and sql agent service
>
>
>3) Right click the data files, select properties, click Advance button,
>check the "Encrypt contents to secure data"
>
>
>4) Start the SQL Server service

All of which presumably can be done programmatically since this is to be
a distributed app?

---
Stefan Berglund