Solved

Linked Server Error Message

Posted on 2011-03-15
5
785 Views
Last Modified: 2012-05-11
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.
 etc.
0
Comment
Question by:Favorable
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 35140447
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?
0
 

Assisted Solution

by:Favorable
Favorable earned 0 total points
ID: 35243783
please close question.
0
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 500 total points
ID: 35244704
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.
0
 

Author Comment

by:Favorable
ID: 35389418
I have requested question closed.
0
 

Author Closing Comment

by:Favorable
ID: 35414487
accepted
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now