Microsoft SQL Server 2005 Express Security

My Company提供MS SQL Server 2005 Express数据库.mdf文件及其解决方案。我们在首次运行应用程序软件时附加在客户端的计算机上的SQL服务器（没有管理工作室）。现在我的老板要我锁定数据库，以便即使他们自己安装管理工作室而没有用户名 - ''sa''和密码，也没有人能看到数据库。

什么他想要的是 - 只有使用具有确切密码的sa的登录才能看到，访问或使用数据库。甚至客户端计算机或客户端计算机的SQL服务器管理员的管理员帐户也无法看到数据库。



甚至可能，我搜索了但是没有任何事情变得有前途和清晰......

提前致谢









如何为我的数据库设置权限或安全角色或用户或登录或实例，以便无论人们通过何种身份验证，都无法访问我的数据库。这意味着如果客户端的用户使用Windows身份验证，则mydatabase不应该对他可用。只有使用服务器身份验证登录并使用选定的用户名和密码才能让用户访问mydatabase。

My Company supplies the MS SQL Server 2005 Express database .mdf files with their solution. Which we attach at client''s computers SQL server (Doesn''t have the Management studio) on first run of the application software. Now my boss wants me to lock the database so that no one can even see the database even if they install management studio on their own without the username-''sa'' and password for it.
What he wants is- The database can only been seen or accessed or used by using logins for sa with exact password. Even the administrator account of client''s computer or client computer''s SQL server administrator cant even see the database.

Is it even possible, I have searched for it but nothing came up as promising and clear.....
Thanks in advance




How to set permission or security roles or users or logins or instance something like that for my database, so that No one have access to my database whatever authentication they passed. That means if user at client use windows authentication mydatabase shouldn''t be available to him. only login using server authentication and with a selected username and password let user to access mydatabase.