Re: Linked Server Between two machines in different domains with different SQL versions
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Sun, 7 Jan 2007 12:17:17 -0500
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
"alcatraz" <ala.zareini@xxxxxxxxx> wrote in message
news:1168179390.779562.66530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- Prev by Date: Problems in exporting constraints and keys
- Next by Date: Re: Problems in exporting constraints and keys
- Previous by thread: Linked Server Between two machines in different domains with different SQL versions
- Next by thread: Problems in exporting constraints and keys
- Index(es):
Relevant Pages
|
