title: Protecting my database files
body: <p>I have a Windows .net application using SQL Server 2005 Express as database, which is used on a server with multiple clients. The users insert, view and update data via the application.</p>
  
  <p>For this, I have to put the .mdf files in a folder on the server. Is there any other way?</p>
  
  <p>Now in this case, anybody can take those .mdf files and open them in their SQL Server &amp; view the database objects such as tables,views and procedures.</p>
  
  <p>Therefore, I want to protect my .mdf files with high-level or maximum security and ensure that :</p>
  
  <ol>
  <li><p>no one can even copy those files from the server.</p></li>
  <li><p>if the files are copied then they themselves should not open,</p></li>
  <li><p>if opened then they should ask for passwords</p></li>
  </ol>
  
  <p>So, please guide me how to implement this security?</p>
  
  <p>Also, I want to know when someone copies the database files, then whether the user, logins, roles are also copied or not?</p>