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.ConnectionInfo)
 NamedPipes Provider: Could not open a connection to SQL Server (53)
 OLE DB provider 'SQLNCLI10' for linked server ----------------returned message Login timeout expired.
Who is Participating?
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
If the timeout expired, it usually means one a few things things:
The linked server isn't set up properly - it's attempting to connect to a different IP or port than the one the remote server is using
Remote server is not currently listening for new connections (or running at all)
Remote server access is blocked by some kind of firewall or restriction

Can you confirm that you can connect to the remote server via other client tools? Are there any firewalls in place between your SQL Server and the remote server you're connecting to?
FavorableConnect With a Mentor Author Commented:
please close question.
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
Did my response answer your question, or did you find another solution? You can close the question yourself by either selecting my answer, or by requested that it be closed for another reason.
FavorableAuthor Commented:
I have requested question closed.
FavorableAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.