I'm pretty much at wits end because I can't see anything that would cause the problem after searching through several blogs.
So my question is can anyone help me with a SS2008 link service to a SS2005 instance?
The scenario is this:::
I am having trouble with a SS2008 linked server connection to a SS2005 (limited install) server. The SS2005 server has been running perfectly fine for the past few years and we are upgrading our development environments to SS2008.
The SS2005 BOUNCEBAK server is linked to by several of our other SS and Oracle databases and continues to work perfectly as a linked server to other servers.
The SS2008 server I am working with has working linked server connections to other SS2005 servers and is not giving any errors. Named pipes is turned on and TCP is higher in the configuration order for communications protocols.
I have added a synonym name for the target server called BOUNCEBAK which is our company standard and is identical to what other servers have in their configuration.
I am able to connect to the BOUNCEBAK SS2005 server using the synonym in a management studio connection, so I'm pretty sure its not the synonym.
I have setup and verified by login a common user on the two servers (i.e. TestUser) with the same password on both (so as to make the test process simpler).&n
View Complete Post