I have 3 servers in this equation
server1 server2 and link1
I can create a linked server between server1->link1
I get an error when I try and do the exact same thing
between server2->link1
Error:
TCP Provider: An existing connection was forcibly closed by the remote
host.
Login failed for user reader
OLE DB provider "SQLNCLI" for linked server "link1" returned message
"Communication link failure". (Microsoft SQL Server, Error:10054)
So then I went through some troubleshooting on server2
Patch levels of windows and sql server seem to be exactly the same as
server1
I can remote to server2 and register link1 and it connects fine and
also allows
me to run queries.
Any ideas?On Jun 21, 7:26 pm, Mandible <elliottj...@.gmail.com> wrote:
> I have 3 servers in this equation
> server1 server2 and link1
> I can create a linked server between server1->link1
> I get an error when I try and do the exact same thing
> between server2->link1
> Error:
> TCP Provider: An existing connection was forcibly closed by the remote
> host.
> Login failed for user reader
> OLE DB provider "SQLNCLI" for linked server "link1" returned message
> "Communication link failure". (Microsoft SQL Server, Error:10054)
> So then I went through some troubleshooting on server2
> Patch levels of windows and sql server seem to be exactly the same as
> server1
> I can remote to server2 and register link1 and it connects fine and
> also allows
> me to run queries.
> Any ideas?
Are you registerting with TCP IP protocol. Check whether this enabled
on server2 .
Check for any firewall settings which may not be allowing to connect
throgh link server . I hope you enabled remote access allowed on both
the systems
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment