Re: How can I encrypt the MDF file
From: Neil Weicher (neilw@netlib.com)
Date: 02/21/03
- Next message: Neil Weicher: "Re: Encrypting a Column Help"
- Previous message: Tibor Karaszi: "Re: Wiping MS SQL records"
- Next in thread: Neil Weicher: "Re: How can I encrypt the MDF file"
- Maybe reply: Neil Weicher: "Re: How can I encrypt the MDF file"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Neil Weicher" <neilw@netlib.com> Date: Fri, 21 Feb 2003 13:15:19 -0500
May I suggest you also take a look at Encryptionizer for SQL Server and
Encryptionizer for MSDE. It supports a wide arrany of platforms, and is
also possible to bundle into an application.
Neil
www.netlib.com
_____________________________________
<news@news.com> wrote in message news:ukmRBG91CHA.2288@TK2MSFTNGP09...
> Encrypted files can only be decrypted (like copied to FAT partition) by
the
> nt account with which they were created, ergo, you'd need sysadmin to run
> the xp_cmdshell or the service acct password to do it. Should be secure.
>
>
> "Richard Siddaway" <rsiddaw@hotmail.com> wrote in message
> news:26eb01c1f860$22c0e3e0$3bef2ecf@TKMSFTNGXA10...
> > Even using EFS it would be possible to copy the mdf file
> > onto a FAT32 partition thereby unencrypting and then
> > attach to another instance of SQL server
> >
> > >-----Original Message-----
> > >You could use EFS - we fully support it. You must log in
> > as the SQL Server
> > >service account and encrypt the database files using that
> > account while SQL
> > >Server is shut down. They would not be encrypted nor
> > readable outside of
> > >that service account.
> > >
> > >Ranjit
> > >
> > >
> > >Disclaimer:
> > >-----------
> > >
> > >This posting is provided "AS IS" with no warranties, and
> > confers no rights.
> > >
> > >Are you secure? For information about the Strategic
> > Technology Protection
> > >Program and to order your FREE Security Tool Kit, please
> > visit
> > >http://www.microsoft.com/security.
> > >
> > >.
> > >
>
>
- Next message: Neil Weicher: "Re: Encrypting a Column Help"
- Previous message: Tibor Karaszi: "Re: Wiping MS SQL records"
- Next in thread: Neil Weicher: "Re: How can I encrypt the MDF file"
- Maybe reply: Neil Weicher: "Re: How can I encrypt the MDF file"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
