Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool' in IIS7

May 20, 2011
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 

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 RSS subscribe by email Subscribe by Email

32 comments :

Anonymous said...

cool that works for me,
thank you very much

Anonymous said...

cool that works for me,
thank you very much

Anonymous said...

could you please suggest the same solution in windows XP ?

Anonymous said...

Thanks for this. Works for me.

Anonymous said...

it worked for me aswell. Thank you very much. but would you explain what i did.

Anonymous said...

Worked Thanks
Bharat

Anonymous said...

thx m8, worked!

adil khan kakakhel said...

jazakallah dear. and thanks a lot.from adil khan kakakhel.
assistant professor bach khan university khyber pukhtunkhwa charsadda peshawar.

Anonymous said...

Thanks it worked like a charm....

Anonymous said...

really working
thanks...

Anonymous said...

thanks

Pankaj Nema said...

Thanks a lot.

Anonymous said...

Works for me - big thanks

Felipe said...

Thanks!

Anonymous said...

thank you very much...it did sort out my problems... :)

hermes said...

Amazing work! After seen those errors I decided to write this post to help people who are need with this error.

Dhiraj Kumar said...

Thank a lots. Such a nice article

Rohit .Bhardwaj said...

It is not working for me.. :(

expert advice said...

Thank you, that helps me a lot!

Lakshmi said...

Thank You very much..

Anonymous said...

thanks :-D

Jegan Nathan said...

You are very great no words to say super

raj said...

Thank you sir...

Anonymous said...

Alhamdulillah Working fine for me

Anonymous said...

what about security issue?

Pablo Mora González said...

awesome, never experience this problem, but now ok, it seems was kind of domain that changes config.
Cheers.

Jayakrushna Mahapatra said...

Thanks for the help. It worked for me also

Ashok Tewatia said...

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.

Hemanth Valsalan said...

thanks

Mathew Poothullil said...

Thanks, Good Stuff. Keep going

Bill said...

Thank you for taking the time to publish this!
Bill

Anonymous said...

That didnt work for me :)

Give your Valuable Comments

Other Related Posts

© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.