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 ««12

Named Pipes Provider: Could not open a connection to SQL Server [53] Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 4:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 6:34 AM
Points: 7,108, Visits: 6,274
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?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1423996
Posted Wednesday, February 27, 2013 10:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 1, 2013 2:49 PM
Points: 2, Visits: 14
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.
Post #1424636
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse