Re: Securing the MDF file

You can encrypt data in the database. If you do that and you lose the
database, the "finder" won't be able to decrypt it after attaching it to his
own server.

You may also want to have a look at the following related threads:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=52094&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=371562&SiteID=1

Thanks

--
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/

This posting is provided "AS IS" with no warranties, and confers no rights.

"Ken Hundley" <KenHundley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29A512D9-C866-4755-A072-DCF3CEC61447@xxxxxxxxxxxxxxxx
Is there anyway to secure a database so that if someone stops the server
and
copies the MDF file to a different system it will prevent them from
opening
the file and reading the information in that database file?

Thanks


.

Relevant Pages

  • Re: Encrypting data in SQL 2005
    ... Why not have the application request the password when the authorized user ... logs in to the database. ... addition to the credentials required for connecting to the database. ... Software Design Engineer ...
    (microsoft.public.sqlserver.security)
  • Re: Attach database became readonly
    ... my problem becomes how to install it so that it is set to Local System. ... attached database behave as normal (i.e. it on longer is readonly ... I install my application on user machine using Visual Studio setup ... What should I do so that after attaching it is not a readonly ...
    (microsoft.public.sqlserver.setup)
  • Re: Attach database became readonly
    ... This posting is provided "AS IS" with no warranties, ... attached database behave as normal (i.e. it on longer is readonly ... I install my application on user machine using Visual Studio setup ... What should I do so that after attaching it is not a readonly ...
    (microsoft.public.sqlserver.setup)
  • Re: repairing damaged sql server MDF and LDF files
    ... Can you post the error you are getting while attaching the database. ... If the MDF file is corrupted you have to either contact Microsoft product ... manage to get back the data files and reinstall the sql server. ...
    (microsoft.public.sqlserver.server)
  • Re: jeff
    ... Login to SQl server using the Query analyzer and try attaching the MDF file ... If the database is not detached earlier ...
    (microsoft.public.sqlserver.clients)