个人理解 数据库服务器之间不存在信任或者不信任的问题 一般我们说的信任关系 是指用同一个帐号非明文用户名或者密码访问登录数据库服务器,比如用域身份链接那就是两回事了,因为域管理那是非常方便的.比如你用域管理员身份登录,默认在每个sqlserver上都是管理员的级别.比如楼上的这样赋予某个域用户以登录某个服务器的权限就是以下是抄自msdn,参考一下SQL Server 2000 uses two types of authentication: Windows Authentication and SQL Server Authentication. When using Windows Authentication, you do not have to specify a login ID or password when you connect to SQL Server 2000. Your access to SQL Server 2000 is controlled by your Windows NT or Windows 2000 account or group, which is authenticated when you log on to the Windows operating system on the client. When you connect, the SQL Server 2000 client software requests a Windows trusted connection to SQL Server 2000. Windows does not open a trusted connection unless the client has logged on successfully using a valid Windows account. The properties of a trusted connection include the Windows NT and Windows 2000 group and user accounts of the client that opened the connection. SQL Server 2000 gets the user account information from the trusted connection properties and matches them against the Windows accounts defined as valid SQL Server 2000 logins. If SQL Server 2000 finds a match, it accepts the connection. When you connect to SQL Server 2000 using Windows 2000 Authentication, your identification is your Windows NT or Windows 2000 group or user account.
企业管理器-->安全性-->登陆-->新建用户-->windows用户-->域-->下拉筐选种你的域-->允许访问选中-->名称后面选择-->OK
数据库服务器之间不存在信任或者不信任的问题
一般我们说的信任关系 是指用同一个帐号非明文用户名或者密码访问登录数据库服务器,比如用域身份链接那就是两回事了,因为域管理那是非常方便的.比如你用域管理员身份登录,默认在每个sqlserver上都是管理员的级别.比如楼上的这样赋予某个域用户以登录某个服务器的权限就是以下是抄自msdn,参考一下SQL Server 2000 uses two types of authentication: Windows Authentication
and SQL Server Authentication.
When using Windows Authentication, you do not have to specify a login ID
or password when you connect to SQL Server 2000. Your access to SQL
Server 2000 is controlled by your Windows NT or Windows 2000 account or
group, which is authenticated when you log on to the Windows operating
system on the client.
When you connect, the SQL Server 2000 client software requests a Windows
trusted connection to SQL Server 2000. Windows does not open a trusted
connection unless the client has logged on successfully using a valid
Windows account. The properties of a trusted connection include the
Windows NT and Windows 2000 group and user accounts of the client that
opened the connection. SQL Server 2000 gets the user account information
from the trusted connection properties and matches them against the
Windows accounts defined as valid SQL Server 2000 logins. If SQL Server
2000 finds a match, it accepts the connection. When you connect to SQL
Server 2000 using Windows 2000 Authentication,
your identification is your Windows NT or Windows 2000 group or user account.