DSN connection fails when Basic authentication turned on

From: Drew (anonymous_at_discussions.microsoft.com)
Date: 10/29/03

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.


>-----Original Message-----
>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
>establish connection"
>When I turn the basic authentication off and turn on
>anonymous it works fine.
>Any suggestions?