Clever Geek Handbook

Windows Auth per page; Application pool user to database

Is it possible, using an ASP desktop application hosted in IIS 7.5, to use Windows Authentication on the page (so I can access LOGON_USER), but use the Application Pool ID to connect to the database? If I enable Anonymous Authentication and configure it to run as the Application Pool ID, I can connect to the database, but I cannot get LOGON_USER. If I disable anonymous authentication, I can get LOGON_USER, but I cannot connect to the database.

+3


source to share


1 answer


Coworker found this: Obviously setting the physical path credentials in the app's advanced settings will also cause communication with the database on the network. So anonymous auth off, windows auth on, physical credentials set for the service account.



Not sure why this works as I expected Physical Path accounts to only affect disk interactions.

0


source






More articles:


All Articles