Re: NT Authentication/IIS

"timkarnold" <timkarnold_at_home.com> wrote in message news:9IvG7.6419$Ze5.4360022_at_news1.rdc1.md.home.com...
> This is a repost/but I have not found a solution:
>
> - I have a WinNT 4.0/Server machine with IIS 4.0 and Oracle 8.1.6 on it
> (no performance problems)
> - IIS is on a server separate from the Oracle DB
> - I have configured Oracle users authentication as ''External'' and it
> seems to be ok (I can access my DB, create and drop tables and so on...)
> - I have configured ODBC
> - I have set IIS security as ''allow anonymous access + windows nt
> challenge/response''
> - when I execute an ASP page it return my DOMAIN\username correctly
> but
> - when I execute an ASP page to open my DB --> ''An error occurred on
> the server when processing the URL. Please contact the system
> administrator.''
>
> I think problem is that ASP page tries to connect DB as IIS anonymuos
> user and so it is refused: is this the problem? and if yes any solution?

This is indeed the problem. If I understand your problem correctly you wish to use preexisting domain accounts to access the db?

Then I believe what should work is as follows.

1. Configure IIS NOT to use anonymous access.
2. set the connection string in you asp page to be something like "DSN=BLAH;UID=/;"
3. Obviously the database has to have user created with the identified externally clause but you say that you have done this.

I'll try and try this out in a spare moment .

--
Niall Litchfield
Oracle DBA
Audit Commission Uk