StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POIs it possible to password protect an SQL server database even from administrators of the server?
text
Body
copied!<p>I want to install an application (ASP.Net + SQL server 2005 express) in local network of some small company for demoing it for a period of time, but I also want nobody <strong>even sysadmin</strong> have no permission on this database and any permission granting wants a secure pass that I have . I just want my tables structure and relations and functions be hidden and encrypting the data have no advantage</p> <p>I need to spend more time on this article <a href="http://msdn.microsoft.com/en-us/library/cc278098.aspx" rel="nofollow noreferrer">Database Encryption in SQL Server 2008 <strong>Enterprise Edition</strong></a> that i found from this answer <a href="https://stackoverflow.com/questions/773899/is-it-possible-to-password-protect-an-sql-server-database/773906#773906">is-it-possible-to-password-protect-an-sql-server-database</a></p> <p>but</p> <p>1.I like to be sure and more clear on this because the <a href="https://stackoverflow.com/questions/773899/is-it-possible-to-password-protect-an-sql-server-database/773916#773916">other answer</a> in this page says :</p> <blockquote> <p>Yes. you can protect it from everyone except the <strong>administrators of the server.</strong></p> </blockquote> <p>2.if this is possible, the db have to be enterprise edition ?</p> <p>3.is there any other possible solutions and workaround for this?</p> <p>4.if I install a new instance with my own sa password , can i restrict other instances admins from attaching the mdf to their own ?</p> <p>thanks in advance</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload