up vote 1 down vote favorite
share [g+] share [fb]

Is there a way to encrypt or password protect MSSQL Server database files so that they can not be used in case they were detached and attached to other DB servers?

link|improve this question
100% accept rate
feedback

1 Answer

up vote 2 down vote accepted

Which version of SQL Server? From 2008 onward, this could be of interest to you: http://msdn.microsoft.com/en-us/library/cc278098(SQL.100).aspx.

That said, you can of course use standard Windows NTFS features: ACLs and file-level encryption.

link|improve this answer
Just what I needed. Thank you very much! – Iyad Aug 17 '10 at 22:07
2  
Do keep in mind that if this is an application which you are selling to customers, the data within the database is theirs and they can do with it as they please. And that includes moving the database from one server to another. – mrdenny♦ Aug 17 '10 at 23:32
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.