Connect to oracle db with windows authentication

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
sivanshk
Posts: 1
Joined: Mon 28 Apr 2014 06:05

Connect to oracle db with windows authentication

Post by sivanshk » Mon 28 Apr 2014 06:08

Hi,

We are using dotconnect 7.9 version.
We are trying to connect oracle db with windows authentication. We use entity framework with oracle client 11.2.
We have a WCF service located on iis 7.5 (Windows 2008 R2 or windows 7).
The client is configured to impersonate the service to client credentials.
Inside the service we can see that the windows identity both on securityContext and the current thread is the client's windows identity.
The iis application pool of the service has a different identity that doesn't have permission to connect the db. We expect that when the service is tring to connect the db it is done with the client's identity (as it works with native ado.net) but we've got an error from the oracle - ORA-01017: invalid username/password; logon denied.
It's seems that instead of client identity the app pool identity is passed to oracle db.

Does anybody has an idea what is the problem?

Thanks

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Connect to oracle db with windows authentication

Post by Pinturiccio » Mon 05 May 2014 15:43

We are investigating the issue and will post here about the results as soon as possible.

Anastasia
Posts: 1
Joined: Wed 20 Aug 2014 12:42

Re: Connect to oracle db with windows authentication

Post by Anastasia » Wed 20 Aug 2014 12:45

Got the same problem? Is there any news?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Connect to oracle db with windows authentication

Post by Pinturiccio » Thu 21 Aug 2014 10:05

We are investigating the issue, but we can't tell any timeframe at the moment.

Post Reply