Re: securing mdf files
From: Stefan Berglund (keepit_at_in.thegroups)
Date: 06/22/05
- Next message: Simo Sentissi: "c2 failed login correlation to an origination IP/host ?"
- Previous message: Michael D. McGill: "SQL Server Error 18452"
- In reply to: Hari Prasad: "Re: securing mdf files"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Simo Sentissi: "c2 failed login correlation to an origination IP/host ?"
- Previous message: Michael D. McGill: "SQL Server Error 18452"
- In reply to: Hari Prasad: "Re: securing mdf files"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]