Linked Server Error Message
I'm trying to set up a linked server.
Both servers runnning SQL Server Std Edi 2008 r2
Ad hoc reporting is enable, but still generating the following error message.
The linked server has been created but failed a connection test. Do you want to keep the linked server?
An exception occurred while executing a Transact-SQL statement or batch (Microsoft-SqlServer.Conne
NamedPipes Provider: Could not open a connection to SQL Server (53)
OLE DB provider 'SQLNCLI10' for linked server ----------------returned message Login timeout expired.
etc.
Both servers runnning SQL Server Std Edi 2008 r2
Ad hoc reporting is enable, but still generating the following error message.
The linked server has been created but failed a connection test. Do you want to keep the linked server?
An exception occurred while executing a Transact-SQL statement or batch (Microsoft-SqlServer.Conne
NamedPipes Provider: Could not open a connection to SQL Server (53)
OLE DB provider 'SQLNCLI10' for linked server ----------------returned message Login timeout expired.
etc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
accepted
ASKER