Re: MDF Password

Am I right in saying that EFS would protect the files from being copied from
one machine to another, but if someone installed Enterprise Manager on the
machine they would be able to view all database objects including data. I
have a particular issue because I am going to be distributing an application
using MSDE, but just wondered if there was any way I could protect the data
from being viewed by unwanting hands. (obviously they would need to know
what they were doing).

Regards

Tim



"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:%238MndvmBHHA.3536@xxxxxxxxxxxxxxxxxxxxxxx
As far as I know there is no mechanism to set passwors for MDF, NDF and
LDF files. As Arnie suggested take a look into EFS.
Take a look into the below article...

http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp

Thanks
Hari

"Timbo" <me@xxxxxxxx> wrote in message
news:OBOxtBcBHHA.4808@xxxxxxxxxxxxxxxxxxxxxxx
Hi Everyone,

Is there any way to give an MDF file a password so that it can't be
attached via Enterprise Manager or command line without knowing it?

TIA

Tim





.

Relevant Pages

  • Re: there are tools ...
    ... Yes, if the goal is to protect data from being stolen, use EFS. ... Syskey doesn't protect the "disk". ...
    (microsoft.public.security)
  • Re: Sam + EFS?
    ... SYSKEY is the best method to protect the SAM. ... Introducing EFS into the loop for high ...
    (microsoft.public.windowsxp.security_admin)
  • RE: Does W2K hold users email, EFS etc private key securely ?
    ... Everything depends on whether you are implementing EFS via GPO or locally, ... a secure hard disk area (at least ... Does W2K hold user's email, EFS etc private key securely? ... prompted for a separate passphrase to protect this key. ...
    (Focus-Microsoft)
  • Re: File protection
    ... Windows 2000 uses ntfs permissions and EFS encryption [which requires ntfs ... file system] to protect access to folders and files. ...
    (microsoft.public.win2000.security)