Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Link Server Connection Expand / Collapse
Author
Message
Posted Monday, April 8, 2013 5:18 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, June 22, 2014 9:45 PM
Points: 422, Visits: 92
Sir,
I am working in Medical college campus.They have 5 server in our campus.
I have done a Port for SQL 1433 Both Server are activate an also Named Pipes Provider are Enable,TCP/IP is Enabled in Both Server.In Configuration Manager SQL Browser is running and SQL SERVER (MSSQLSERVER) also running.When connection Link server the following Error as occurred.


TITLE: Microsoft SQL Server Management Studio
------------------------------
The linked server has been created but failed a connection test. Do you want to keep the linked server?
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Named Pipes Provider: Could not open a connection to SQL Server [53].
OLE DB provider "SQLNCLI10" for linked server "172.17.15.100" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "172.17.15.100" 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)
Post #1439752
Posted Monday, April 8, 2013 10:04 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 3:13 PM
Points: 393, Visits: 2,684
tamil.selvanmca (4/8/2013)
Sir,
I am working in Medical college campus.They have 5 server in our campus.
I have done a Port for SQL 1433 Both Server are activate an also Named Pipes Provider are Enable,TCP/IP is Enabled in Both Server.In Configuration Manager SQL Browser is running and SQL SERVER (MSSQLSERVER) also running.When connection Link server the following Error as occurred.


TITLE: Microsoft SQL Server Management Studio
------------------------------
The linked server has been created but failed a connection test. Do you want to keep the linked server?
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Named Pipes Provider: Could not open a connection to SQL Server [53].
OLE DB provider "SQLNCLI10" for linked server "172.17.15.100" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "172.17.15.100" 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)


- Make sure your windows firewall is either not enabled or if enabled, allows TCP traffic on port 1433 (or whatever port is being used). This assumes of course that your sql servers are not "named instances." Express edition if I'm not mistaken installs as a named instance. Also, your sql browser service uses UDP on port 1434 so maybe you can check that out, however, I don't think its needed for the default instance.

- Make sure if you have a segmented network, nothing is getting blocked by your internal routers. You can test for instance by doing "ping 172.17.15.100" from your client PC at a command prompt.

Ok thats it I'm outta ideas!
Post #1439923
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse