Microsoft SQL Server 2005 Express Security [英] 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.

推荐答案

您只需要设置身份验证模式 [ ^ ] to：SQL Server和Windows身份验证模式。



如何更改身份验证模式？请参阅：如何：更改服务器身份验证模式 [< a href =http://msdn.microsoft.com/en-us/library/ms188670%28v=sql.90%29.aspxtarget =_ blanktitle =New Window> ^ ] 。



请阅读： SQL Server安装的安全注意事项 [ ^ 也是如此。按照相关链接（参见窗口左侧的菜单）。

All you need is to set Authentication mode[^] to: SQL Server and Windows Authentication mode.

How to change authentication mode? See this: How to: Change Server Authentication Mode[^].

Please, read about: Security Considerations for a SQL Server Installation[^] too. Follow the related links (see menu on the left side of window).

这篇关于Microsoft SQL Server 2005 Express Security的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！