Introduction:
In this article I will explain how to solve System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool' problem in IIS7.
Description:
Recently I started working with IIS7 at that time I face some of strange problems to rectify those errors I did some modifications in IIS. After seen those errors I decided to write this post to help people who are need with this error. I did one sample application and deploy application in IIS. I started running my deployed application at that time I get error like this
Recently I started working with IIS7 at that time I face some of strange problems to rectify those errors I did some modifications in IIS. After seen those errors I decided to write this post to help people who are need with this error. I did one sample application and deploy application in IIS. I started running my deployed application at that time I get error like this
System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool'
To solve this problem I made modifications in IIS configuration to make those changes just follow below steps to solve this problem.
Start ---> Open Run and type inetmgr and click OK now our IIS will open
In IIS select Application Pools ---> In that select DefaultAppPool ---> Right Click on DefaultAppPool ---> Select Advanced Settings
 |
After open Advanced Settings one window will open in that select Identity and change path selection for Identity
 |
Now change the Identity path selection from ApplicationPoolIdentity to LocalSystem
 | |
Select Built-in account to LocalSystem click OK now your problem will solve and it will work for you.
|
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email. |
|||
Subscribe by RSS
Subscribe by Email
|
|||
35 comments :
cool that works for me,
thank you very much
cool that works for me,
thank you very much
could you please suggest the same solution in windows XP ?
Thanks for this. Works for me.
it worked for me aswell. Thank you very much. but would you explain what i did.
Worked Thanks
Bharat
thx m8, worked!
jazakallah dear. and thanks a lot.from adil khan kakakhel.
assistant professor bach khan university khyber pukhtunkhwa charsadda peshawar.
Thanks it worked like a charm....
really working
thanks...
thanks
Thanks a lot.
Works for me - big thanks
Thanks!
thank you very much...it did sort out my problems... :)
Amazing work! After seen those errors I decided to write this post to help people who are need with this error.
Thank a lots. Such a nice article
It is not working for me.. :(
Thank you, that helps me a lot!
Thank You very much..
thanks :-D
You are very great no words to say super
Thank you sir...
Alhamdulillah Working fine for me
what about security issue?
awesome, never experience this problem, but now ok, it seems was kind of domain that changes config.
Cheers.
Thanks for the help. It worked for me also
That worked for me. But here i want to know details about Local System, Network system and other options in the dropdown. Please recomend some article which can help in understanding this as well.
thanks
Thanks, Good Stuff. Keep going
Thank you for taking the time to publish this!
Bill
That didnt work for me :)
Thank you Suresh. Your post saved my night :P (working late)
that didn't worked for me
thank you so much ...its working fine
Note: Only a member of this blog may post a comment.