DSN connection fails when Basic authentication turned on

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

Date: Tue, 28 Oct 2003 09:43:24 -0800

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 the
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?

drew

Relevant Pages

  • Re: Windows Authentication security question
    ... Thanks for your reply Roger. ... It is probably more secure than the other even with the ... If your question is about what authN to allow a SQL Server to use, ... SQL Server database has more security than Windows basic authentication ...
    (microsoft.public.win2000.security)
  • I need some advice from the gurus out there
    ... I have a web application that is using basic authentication. ... requirement to ingest excel files in a standard format, ... excel into a sql server 2000 database if ... (still custom code, but less because we have no file transfer). ...
    (microsoft.public.office.developer.web.components)
  • GUID not allowed in Find Method
    ... We are currently are using Access 2003 and going to start using SQL Server ... DSN connection The connection seems to work fine and for the most part the ... ' Find the record that matches the control. ... The value of me!has the correct guid information ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Multiple Apps on System DSN on Server from One PC
    ... > Should I use the same Active-X server for the same in a MS SQL Server ... > DSN connection or is it ok to have multiple apps from the same pc using ... You don't need the ActiveX work-around for SQL Server. ...
    (comp.databases.ms-sqlserver)
  • Ole connection not open sql server
    ... i am using CR 8.0 and vb 6.0 and data base is sql server 2000 my application ... work fine with DSN connection and with ole connection the report is not ...
    (microsoft.public.vb.crystal)