SQL Server Performance Forum – Threads Archive

Latest Security Patch Problems

My ASP apps on Server1 quit working when I connect to SQL Server on Server 2
since I installed the latest Security Patch (Cumulative Patch for Microsoft
SQL Server (815495)) I get this error:
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’ [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or
access denied. I use a DSNLess connection. Any ideas?
———-
T Kelley
MS, MCDBA, OCA, CIW

Check the registry for [Hkey_Local_MachineSoftwareODBC] keys and current user’s permission. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

I managed to find a solution to my problem. Apparently, MS closed off the Named Pipe route I was taking in my DSNLess connection in my ASP Page, so I change my connection configuration to use TCP. As a result all works great, in fact, better and faster. TCP must be a lot faster than Named Pipe. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Thanks for everybody’s help. ———- T Kelley MS, MCDBA, OCA, CIW

]]>