SQL Server连接Pb [英] Sql Server Connection Pb

问题描述

我有三个服务器连接，如10.100.100.2和10.100.100.3和10.100.100.4
10.100.100.4 ... 10.100.100.2和3已添加sp_addlinkedserver ...
从10.100.100.2开始的选择查询10.100.100.4在工作...但是在同一选择查询中却不起作用..错误消息显示为"sa的登录失败"

请执行需要的操作..

Hi,

I have three server connection like 10.100.100.2 and 10.100.100.3 and 10.100.100.4
10.100.100.2 and 3 are added sp_addlinkedserver by 10.100.100.4...
The select query of 10.100.100.4 from 10.100.100.2 working...but in the same select query is not working..Error msg shown as "Login failed for sa"

Please do the needful..

推荐答案

您的登录名不正确.所讨论的SQL服务器上的安全设置不同于其他所有安全设置.如果该查询应该在所有服务器上都可以使用，那么您将需要确保安全性得到了解决.

Your login is incorrect. The security setup on the SQL server in question is different from all the others. If the query is supposed to work on all the servers the same then you will need to see to it that the security gets straightened out.

这篇关于SQL Server连接Pb的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！