January 13, 2011 at 5:43 am
Dear All ,
i have face below problem for linked server pleaser help me asap
OLE DB provider "SQLNCLI10" for linked server "XLTEST_SP" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "XLTEST_SP" 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.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
thnks & Rehards
M Shamim Khan
January 16, 2011 at 7:06 pm
mohammad.shamim 40895 (1/13/2011)
Dear All ,i have face below problem for linked server pleaser help me asap
OLE DB provider "SQLNCLI10" for linked server "XLTEST_SP" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "XLTEST_SP" 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.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
thnks & Rehards
M Shamim Khan
The error message is telling you exactly what you need to check.
It can't find the server XLTEST_SP or this server is not configured to allow remote connections.
Can you connect to the server remotely from the server you have configured the linked server using SSMS?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply