Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is needed (if anything) on the IIS server for ASP.NET access to Oracle via Kerberos

NBSep 27 2018 — edited Oct 5 2018

I'm using Oracle Developer Tools for Visual Studio 2017 (12.2.0.1.0) to create an ASP.NET Intranet application.

The app is using operating system authentication, so the credentials of the logged in user are supposed to be passed to IIS and then to Oracle (USER ID=/ in web.config). Note that the operating system authentication all works fine in a Classic ASP application. So the Kerberos configuration for IIS and the Oracle server are all setup OK.

But now when I try to run the deployed app, I get: ORA-01017: invalid username/password; logon denied

I turned on tracing at the Oracle server and I see my username getting passed to Oracle, but it seems like the issue is that Kerberos is not being used. So I'm wondering if I actually need to install the ODP.NET Managed Driver on the IIS server? Even though the Oracle.ManagedDataAccess.dll file is in the bin directory of the site?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2018

Added on Sep 27 2018

#oracle-developer-tools-for-visual-studio

5 comments

1,485 views