Linked Server Between two machines in different domains with different SQL versions -- sql server clients

alcatraz
1/7/2007 6:16:30 AM

hi everybody

well im trying to create a linked server were the source is a database
on SQL server 2000 and the destination is an SQL server 2005 and the
two servers on different domains

now when i run the openquery statment i get an error says

OLE DB provider "SQLNCLI" for linked server "HR" returned message
"Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "HR" returned message "An
error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote
connections.".
Msg 10061, Level 16, State 1, Line 0
TCP Provider: No connection could be made because the target machine
actively refused it.

and im not sure if i created the linked server correctly, so can anyone
help me in that, and if it was correct and the error was generated
because of another reason can anyone to tell me whats wrong because the
message not that clear for me

Andrew J. Kelly
1/7/2007 12:17:17 PM

One of the messages states that you may have an issue with the 2005 server
not being configured to allow remote access. Have a look at these:

https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

sql server clients : Linked Server Between two machines in different domains with different SQL versions