> Hi, all!  Presently I'm using a Win2K Ad Server w/SQL 7.0 Standard (SP2)
and
> IIS5; also plan to replicate the process to WinNT4 (SP5) w/IIS4 and SQL7
> Standard.

> Here's the question:  I have a directory containing ASP files, and the
> directory has been configured to use Basic Authentication (also tried with
> NTLM, but got same results).  Now, the ASP uses ADO to (attempt) connect
to
> a secured database on SQL7 (same problem whether SQL Server is (local) or
> remote machine).  What I'm trying to accomplish is make the user
> authenticate in their browser when they request the web page, and that
> authentication is used to gain access to the SQL database.  The user in
> question has been added to SQL Server's Security database as an NT user,
and
> not a SQL account (Integrated Security).  In a nutshell, I want a single
> login here.

> Problem: login into SQL server fails each time; the typical error is
"Error
> Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection."

> On KB article (Article ID: Q176380) suggest either a) hosting IIS & SQL on
> the same machine (not possible in my situation), b) using Basic
> Authentication instead of NTLM (tried; no effect), or c) using a trusted
> connection (also not possible in my situation).

> Another KB article suggested using specific settings in the Properties
> collection of the ADODB Connection object to make the connection (it said
to
> use the "Integrated Security" property, which doesn't exist).  Tried, no
> luck.

> What I'm trying to accomplish seems so simple I find it amazing that it
> isn't possible...  is there a mechanism that will allow me to authenticate
> against an NT directory (a web directory), and that authentication is used
> to authenticate into SQL Server against an Integrated Security account,
with
> either NTLM or Basic Authentication?!?!!

> Thanks in advance,
> SteveB