如何为SqlServer 2005数据库设置密码
尊敬的专家!
我正在Asp.net,c#,SqlServer 2005上工作
在我的公司中,我有一个名为(Hyd09)的服务器,这些服务器已连接到所有人,每个人都可以访问它.
在这些SERVER中,我们有一个SqlServer 2005数据库.每个人都将在此服务器上创建数据库并连接到他们的Asp.net项目.
我想为我的数据库提供密码....以便没有人可以打开我的数据库.只有我应该访问我的数据库.
请建议我该怎么做?这对我来说非常重要.我迫切需要它.
谢谢.
Dear Experts !!
Am working on Asp.net , c#, SqlServer 2005
In My company I have a Server called(Hyd09), these server is Connected to Everyone, and Everyone will access it.
In these SERVER we have a SqlServer 2005 Database. Everyone will create Database in this server and connect to their Asp.net Projects.
I want to Give Password for my Database....so that No one can open my database. Only i should access my database.
Please suggest me How to do this ? Its very important to me. I need it urgently.
Thanks.
连接到服务器.
创建数据库
在安全性中->登录->创建新的登录名
常规选项卡-登录名,SQL SERVER身份验证,选择默认数据库
用户映射标签->选择数据库,授予安全权限
Connect to the server.
Create a Database
In the security -> Login -> Create New Login
General tab - Login Name, SQL SERVER Authentication , Select default database
User Mapping Tab -> Select Database, Give the security permission