DSN connection fails when Basic authentication turned on
From: Drew (anonymous_at_discussions.microsoft.com)
Date: Wed, 29 Oct 2003 11:01:28 -0800
Traced the fault down to using named pipes in the DSN
connection. Changed to TCP/IP and now works.
>Just rebuilt my Web server and added back all the user
>accounts. When I switch on Basic Authentication, the ASP
>that pull information from the SQL server fail to make
>DSN connection with the following message:-
>"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>[Microsoft][ODBC SQL Server Driver]Client unable to
>When I turn the basic authentication off and turn on
>anonymous it works fine.