Latest Security Patch Problems | SQL Server Performance Forums

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
Check the registry for [Hkey_Local_MachineSoftwareODBC] keys and current user’s permission. _________
Satya SKJ

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=’:)‘ /><br /><br />Thanks for everybody’s help.<br /><br /><br /><br />———-<br />T Kelley<br />MS, MCDBA, OCA, CIW<br /><br />