Search code examples
sql-serveriiswindows-authenticationapplication-pool

IIS Application Pool and Sql Server Windows Authentication

I have an app running within IIS, inside an Application pool running under a User with SQL Server access.

Windows authentication doesn't seem to be picking up the User's account though.

Any ideas on how I can proceed with this? It's really confusing

Solution

  • Make sure you have unmarked anonymous user on IIS otherwise it won't pick up the user name