How to fix the Login failed for user ‘IIS APPPOOLASP.NET v4.0’ error in IIS7 and Sql Server 2008

The Problem: You are trying to access a sql server database from your new ASP.net 4.0 site and get the error Login failed for user ‘IIS APPPOOLASP.NET v4.0’ error in IIS7 and Sql Server 2008 when logging in with the integrated security.

The Cause: The new default user for asp.net 4.0 does not have default login permissions.

The Solution: I was going to write this up, but GotToKnow.com does such an excellent job I thought I would just link to their post Login failed for user ‘IIS APPPOOLASP.NET v4.0’ error in IIS7.  It is an excellent site for that sort of information.

 

This post originally appeared on the Stronico blog – with the absorption of Stronico into Digital Tool Factory this post has been moved to the Digital Tool Factory blog

 

Written By Steve French

 

This entry was posted on Friday, October 29th, 2010 at 11:03 pmand is filed under ASP.net, How To Fix . You can follow any comments to this entry through the RSS 2.0 feed. You can leave a comment, or trackback from your own site.

One response to “How to fix the Login failed for user ‘IIS APPPOOLASP.NET v4.0’ error in IIS7 and Sql Server 2008”

1. http://www.gotknowhow.com/articles/fix-login-failed-for-user-iis-apppool-aspnet-v4-error-iis7
   please take a look bye

   Reply

 

 

Latest Tweets & Social