链接服务器无法登录 [英] Linked server fails to login
问题描述
Hello All,
我使用sqlserver用户创建了一个链接服务器。我上周工作正常,但由于电源问题,我的主要人员改为中学。我把它故障转回了主要版本,但是我无法使用链接服务器进行查询。它给出了一个错误"与链接服务器的
测试连接失败。"
我验证了我能够使用rmtuser凭据登录到sql server,但是不是通过链接服务器。
感谢任何帮助。
谢谢,
Suresh
如果您尝试运行查询,例如
SELECT * FROM thatserver.master.sys.databases
您会收到什么错误消息?
Hello All,
I have created a linked server using a sqlserver user. I was working fine last week, but due to power issues, my primary changed to secondary. I failed over it back to the primary, but I'm not able query using the linked server. It gives an error "The test connection to the linked server failed."
I verified that I am able to login to the sql server using the rmtuser credentials, but not through the linked server.
Any help is appreciated.
Thanks,
Suresh
If you attempt to run a query like
SELECT * FROM thatserver.master.sys.databases
what error message do you get?
这篇关于链接服务器无法登录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!