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"
Thank you for the tips, this is exactly what I was looking for, and it is working fine now.
ReplyDeleteThank u so much ... that was really helpfull
ReplyDelete
ReplyDeleteIt 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