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.ConnectionInfo)
NamedPipes Provider: Could not open a connection to SQL Server (53)
OLE DB provider 'SQLNCLI10' for linked server ----------------returned message Login timeout expired.