Wednesday, July 29, 2015

[Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53].

SQLState = 08001, NativeError = 53

Error = [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53].

SQLState = 08001, NativeError = 53

Error = [Microsoft][ODBC Driver 11 for SQL Server]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.

SQLState = S1T00, NativeError = 0

Error = [Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired

This is a error i have got when my program is trying to connect to a SQL Server 2012 using named pipe.

I did a little google and found below article and followed it very carefully and still i got the error.

https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

Futhur digging my syl server is in different active directory.

Ex. SQLS.domain1.com (IP: 10.8.2.204)

and my client is in onother active directory.

Ex. client.domain2.com (10.100.2.35)

When I add the host entry i did it in a write way with fully qualified name.

image

But it didnt work , because named pipe are using with in the same subnet

so i did a litle trick i have added the following host entry also.

image

So it will see the machine using machine name though it is in a different domain.

But this worked.

Post a Comment