Home Forums SQL Server 2005 Administering Named Pipes Provider: Could not open a connection to SQL Server [53] RE: Named Pipes Provider: Could not open a connection to SQL Server [53]

  • February 27, 2013 at 10:14 am

    #1591637

    Brandie Tarvin (2/26/2013)

    AEdel (2/25/2013)

    We began getting the following error this morning, from a php script that's been running for months:

    [25-Feb-2013 01:10:17] PHP Warning: odbc_connect(): SQL error: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53]. , SQL state 08001 in SQLConnect in C:\Admin\Scripts\extract_to_sqlserver.php on line 665

    The script connects to the local host, and was using the IP address "192.168.0.40". When we changed it to "localhost", it started working again.

    Now, to figure out what changed in the environment that caused the IP to stop working all of a sudden...

    Maybe your localhost lost its DHCP lease?

    Our IT dept. rebooted the server, and it resolved whatever the problem was... since this is a database server, it's configured to use a static IP.