Hi,
The distributed query seems to work on the management studio of the server where I have linked the other server to but not accross the network on other management studio with the same impersonated logins. The error I get is.
OLE DB provider "SQLNCLI" for linked server "usbo-sql01" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18452, Level 14, State 1, Line 0
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Are you sure that you are connected to the Management Studio with a Windows User not with a SQL Server login ? Seems that the WIndows context was not passed through as if you were logged with a sql server login.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
The wierdest thing happened.
I exuectue a distributed query on my management studio with my windows credentials, it doesnt work.
I log on to the sql server where I have linked the other server and executed the query with windows authentication as myself, it works.
Then I execute it back on my machine it works.
Then I log out of the main sql server and try on my machine , the query doesnt work.
There is something going on with remote connection.
|||Hi,I guess your SQL Server is just not set up for deleating the security in your network.
-Jens Suessmeyer.|||But what should I do such that the remote query works without me trying to log in to the main server|||Please refer to http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx to see if it solve your issue.
No comments:
Post a Comment