LINKED SERVER PROBLEM

HI!

I try to link a ms 2008 to a ms 2005, but recive error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

"The linked server has been created but failed a connection test. Do you want to keep the linked server?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "XX-XX-XXXXX".
OLE DB provider "SQLNCLI" for linked server "XX-XX-XXXX" returned message "Unable to complete login process due to delay in opening server connection". (Microsoft SQL Server, Error: 7303)

The linked server connection from 2008 to this 2005 server goes fine...

LVL 1
myhrvoldAsked:
Who is Participating?
 
myhrvoldConnect With a Mentor Author Commented:
Hi!

I set the TCP port 1433 on the 2008 server open and wallah.
0
 
HumpdyCommented:
I take it you mean you're trying to connect a linked server from 2005 to 2008 ?
seeing as you said

"The linked server connection from 2008 to this 2005 server goes fine..."

if so,
you can't create linked server from 2005 to 2008
0
 
HumpdyCommented:
sorry, ignore, that,
you can do it

what's in your sql logs and event viewer ?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
myhrvoldAuthor Commented:
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "XX-XX-XXXXX".
OLE DB provider "SQLNCLI" for linked server "XX-XX-XXXX" returned message "Unable to complete login process due to delay in opening server connection". (Microsoft SQL Server, Error: 7303)
0
 
myhrvoldAuthor Commented:
Hi!

If i disable the fireall on the 2008 server it is working fine.... What kind of rule should i create?
0
 
myhrvoldAuthor Commented:
I found it out myself....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.