Linked Server Question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Linked Server Question

Author

Topic

qman
Constraint Violating Yak Guru

442 Posts

Posted - 2011-07-13 : 09:41:20

I have recently migrated one of our SQL Servers to 2008 R2.
I have created two Linked Servers which reference 2005 SQL Servers.
After creating the Linked Servers, I am unable to test the connection. I get the following for the error:

Named Pipes Provider: No process is on the other end of the pipe.
..... unsupported version of SQL Server.....

Is SQL 2008 not backward compatible with 2005 in reference to Linked Servers...?

Thanks
Q

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-13 : 11:15:42

It's compatible. How did you make the linked server? What provider and security context are you using?

qman
Constraint Violating Yak Guru

442 Posts

Posted - 2011-07-13 : 11:26:18

I chose SQL Server as the Server Type. For the Security, I am using "Be made using the login's current security context". This is how it is defined on other non 2008 machines, which works fine.

Thanks
Q

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-13 : 12:01:47

Works for me.

SPN is set?

qman
Constraint Violating Yak Guru

442 Posts

Posted - 2011-07-13 : 13:18:17

Pardon my ignorance, what is SPN?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-13 : 13:19:45

http://msdn.microsoft.com/en-us/library/ms191153.aspx

By the way, firewall isn't blocking requests is it?