SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Named Pipes Provider: Could not open a connection to SQL Server [53]


Named Pipes Provider: Could not open a connection to SQL Server [53]

Author
Message
Brandie Tarvin
Brandie Tarvin
SSC-Dedicated
SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)

Group: General Forum Members
Points: 37049 Visits: 9268
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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
AEdel
AEdel
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search