Page 1 of 1

Connect to oracle db with windows authentication

Posted: Mon 28 Apr 2014 06:08
by sivanshk
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

Re: Connect to oracle db with windows authentication

Posted: Mon 05 May 2014 15:43
by Pinturiccio
We are investigating the issue and will post here about the results as soon as possible.

Re: Connect to oracle db with windows authentication

Posted: Wed 20 Aug 2014 12:45
by Anastasia
Got the same problem? Is there any news?

Re: Connect to oracle db with windows authentication

Posted: Thu 21 Aug 2014 10:05
by Pinturiccio
We are investigating the issue, but we can't tell any timeframe at the moment.