I have an asp.net 2.0 application that uses IIS 6.0 with Windows Authentication and accesses an Oracle 10g x64 Windows 2003 server. Authentication works fine on development where I run IIS and the instance of IE that I use to access the application. I have impersonation turned on and can access the Oracle database as the domain user I logged into the development machine with using the following test connection:
WindowsIdentity idA = System.Security.Principal.WindowsIdentity.GetCurrent();
WindowsImpersonationContext wic = idA.Impersonate();
using (Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection("Data Source=boimisc;User Id=/"))
{
conn.Open();
}
wic.Undo();
This works great and I show up in the Oracle audit log as my domain user. The problem starts when I migrate the asp.net application ...
Go to the complete details ...