链接服务器登录失败 [英] Login Failed for linked server

问题描述

如何创建链接服务器...?

How to create a linked server...?

1st Server name is ABC.DATABASE1
2nd server name is EFG.DATABASE2

EFG 数据库用户名是 sa 密码是 sa

EFG database username is sa password is sa

我想从第二台服务器到第一台服务器检索数据

I want to retrive the data's from 2nd server thourgh 1st server

在第一个服务器中，我像这样执行存储过程....

In the 1st server, i exectue the store procedure like this....

exec sp_linkedserver 'EFG'

执行成功，

当我尝试检索数据时，它显示错误为用户 sa 登录失败，原因:与受信任的 sql server 连接无关"

When i tried to retrive the data, it is showing error as "login failed for user sa, Reason: Not associated with trusted sql server connection"

如何解决这个问题...

How to solve this problem...

需要帮助

推荐答案

在 Microsoft SQL Server Management Studio 中，在 *Security" 选项卡上检查链接服务器属性的登录配置，并为本地 创建映射远程登录sa 帐户或为所有连接配置备用登录.

In Microsoft SQL Server Management Studio check the login configuration of your linked servers properties on the *Security" tab and create a mapped remote login for your local sa account or configure an alternative login for all connections.

要通过执行 sp_linkedserver 创建一个带有登录映射的链接服务器，请尝试

To create a linked server with a login mapping by executing sp_linkedserver, try

sp_addlinkedsrvlogin @rmtsrvname = N'EFG', @locallogin = N'sa', @useself = N'False', 
                     @rmtuser = N'your_remote_user', @rmtpassword = N'remotepassword'

要使用备用登录创建链接服务器，请尝试

To create a linked server with an alternative login, try

sp_addlinkedsrvlogin @rmtsrvname = N'EFG', @locallogin = NULL , @useself = N'False', 
                     @rmtuser = N'your_remote_user', @rmtpassword = N'remotepassword'

这篇关于链接服务器登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！