We have an ASP 2.0 web application (Win2k3 IIS 6.0), with IUSR (using impersonation) we are able to write to a remote directory, using a synchronized IUSR account on the remote server.
When using the same ASP 2.0 Web app, when we try to write to the same remote directory using ADOX to create an MDB file, we are not able to. It seems when ADOX is creating the MDB it does not use impersonation, but rather Network Serivce. Is there a way to force ADOX and JET4 to use impersonation when creating the database?
This blog post speaks to the issue, although this doesn't clear it up for me
http://blogs.msdn.com/david.wang/archive/2005/06/29/IIS_User_Identity_to_Run_Code_Part_2.aspx
Specifically see this comment in the blog post:
http://blogs.msdn.com/david.wang/archive/2005/06/29/IIS-User-Identity-to-Run-Code-Part-2.aspx#572784
Thanks,
Dan