Tuesday, October 5, 2010

Dealing with error "Login failed for user ‘IIS APPPOOL\DefaultAppPool" on Windows 7.

The cause of this error is that a login is being attempted to a database with the "ApplicationPoolIdentity" account. In a development environment, you would prefer using your credentials to log into a SQL Express database. This can be fixed by doing the following:

  • Go to IIS Manager
  • Click on Application Pools
  • Click on the offending application pool
  • Click on the "Advanced Settings ..." link on the right-hand-side
  • Find the "Identity" property and change it from "ApplicationPoolIdentity" to "LocalSystem"

3 comments:

  1. Thank you for the tips, this is exactly what I was looking for, and it is working fine now.

    ReplyDelete
  2. Thank u so much ... that was really helpfull

    ReplyDelete


  3. It is useful to learn how to set and reset a error.Thank you author for posting this kind of error.

    http://www.wikitechy.com/fix-error/login-failed-for-user


    Both are really good.
    Cheers,
    Venkat

    ReplyDelete