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"
Posted by at
Labels: ,

3 comments:

  1. AnonymousDecember 29, 2010 at 1:06 AM

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

    ReplyDelete
  2. AnonymousFebruary 1, 2011 at 11:51 PM

    Thank u so much ... that was really helpfull

    ReplyDelete
  3. UnknownAugust 22, 2016 at 9:55 PM



    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

Subscribe to: Post Comments (Atom)