Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1067
  • Last Modified:

ODBC SQL Server Driver Named Pipes

My client added some Microsoft Windows patches over the weekend and now their application is not working.  Their SQL Server Database is set up on a cluster.

This is the error that my client came up with:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not
found.

This is what I have in the global.asa for the connection string:
Session("strUConnect")  = "Driver={SQL Server};Server=(local);uid=xxxxxxx;pwd=xxxxxxx;database=xxxxxxx"

What could have cause their application to stop working just because they added some Microsoft Windows patch.

URGENT - Thank you!

0
oshe127
Asked:
oshe127
1 Solution
 
curtis591Commented:
if you run cliconfg.exe is has the default communication for your sql server entry been changed to named pipes.  I am guessing if you switch it to IP it will work.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Check out the Server and Client Network tools from SQL Server, there you can see which network protocols are enabled. Normally, you choose the TCP/IP as default protocol (at the server and at the client), and it should work fine. I guess that the patch has reset the default to named pipes (silly NT)...

CHeers
0
 
oshe127Author Commented:
We are having them check the utility now for TCP/IP and they are adding the exact name of the cluster in the server instead of it being local.
0
 
TheSpiritCommented:
You don't give away the versions of SQL/OS that are being used but you might want to checkout the Q article that documents rebind.exe Q239473 after OS updates.
0
 
oshe127Author Commented:
Thanks!

The IP was half of the problem the other half was the global.asa, didn't have the cluster name it still said local.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now