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
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@.gmail.com> wrote in message
news:1168179390.779562.66530@.i15g2000cwa.googlegro ups.com...
> 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
>
Friday, March 9, 2012
Linked Server Between two machines in different domains with different SQL versions
Labels:
create,
database,
databaseon,
destination,
domains,
everybodywell,
linked,
machines,
microsoft,
mysql,
oracle,
server,
source,
sql,
versions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment