September 12, 2011 at 8:47 am
I am trying to setup a linked server between one of our other remote locations. I can add the server in Mgmt Studio just fine, however when I try to link to it I get
Named Pipes Provider: Could not open a connection to SQL Server [53].
OLE DB provider "SQLNCLI10" for linked server "SQBE02COLO" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "SQBE02COLO" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
September 12, 2011 at 9:44 am
It's a networking issue.
Can you connect to the remote server from your laptop/desktop?
If it works from your computer and it doesn't work from your server, probably it's a firewall issue.
-- Gianluca Sartori
September 12, 2011 at 9:46 am
Fixed it by using IP instead of name.
September 12, 2011 at 9:49 am
Glad you sorted it out.
-- Gianluca Sartori
September 12, 2011 at 5:06 pm
IP addresses work very well in case of the Linked Servers. We had similar resolutions in the past. But this works only as long as the IP doesn't change for the SQL Server.
Thank You,
Best Regards,
SQLBuddy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply