sa用户在sqlserver 2008 r2问题。 [英] sa user in sqlserver 2008 r2 problem.

问题描述

我创建了连接到db的dll文件，并且工作正常。我已经安装了新服务器，在这台服务器上我正在安装这个软件。但是对于sa用户连接的新服务器问题。所以请告诉我如何在db上定义sa用户。

i am created dll file for connection to db and it fine working. And i have install new server , at this server i'm installing this software. but on new server problem in connection on sa user. so please tell me how to define sa user on db.

推荐答案

你不应该通过你的软件作为sa用户连接 - 它是一个超级用户ID这是默认设置的，非常危险 - 它应该从SQL实例中删除，或者至少更改名称和密码以防止未经授权的人访问系统 - 在这种情况下听起来就像它一样。 />


您应该创建具有访问所需特定数据库权限的用户，并将他们的权限限制为完成工作所需的最低限度 - 给通用完全权限对应该只添加，选择和更新记录的用户ID，因为这会给未经授权的人员提供另一条复制或损坏数据库的途径。



或许，您需要与设置SQL实例的人交谈，并找出您应该使用的用户ID而不是sa。

You should not be connecting as the sa user through your software at all - it is a super user ID which is set up by default, and is extremely dangerous - it should be removed from the SQL instance, or at least have the name and password changed to prevent unauthorised people accessing the system - and it sounds like it has in this case.

You should create users with permission to access the specific database(s) they need, and limit their permissions to the minimum needed to do their job - it is dangerous to give "generic full permissions" to a user id that should only add, select and update records as that gives unauthorised people another route to copy or damage your DB.

Probably, you need to talk to whoever set up the SQL instance, and find out what user ids you should be using instead of sa.

这篇关于sa用户在sqlserver 2008 r2问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！