[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Linked Server Error Message

Posted on 2011-03-15
5
Medium Priority
?
791 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

656 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