I am trying to access the oracle database using
using System.Data.OracleClient;
from the console application, access to the database is fine. however, from the ASP.NET website I get an error:
ORA-12640: Authentication adapter initialization failed
I searched googled and found that modifying the sqlnet.ora file would solve the problem
SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)
Later, I found another application on the same server that uses a different Oracle database, also requires that the SQLNET.AUTHENTICATION_SERVICES value be "NTS". This will cause my website to not be able to access the database with error ORA-12640. I tried "EVERYTHING" as a value, but still it did not work.
How to configure my site to access the oracle database while sqlnet.ora is configured as "SQLNET.AUTHENTICATION_SERVICES = (NTS)"?
P.S. - Windows :
<authentication mode="Windows"/>
<identity impersonate="true"/>