Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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