Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 2 down vote accepted

Which version of SQL Server? From 2008 onward, this could be of interest to you:

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


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.