Author: cadam59 | Posted on: 3/12/2009 7:35:15 AM | Views : 414

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 ...