Login failed for user 'IIS APPPOOL Classic .NET AppPool' when trying to connect to a SQL SERVER using Windows Authentication

5. March 2013

The solution i found for this problem is on this blog post .

 

http://stackoverflow.com/questions/4736140/login-failed-for-user-iis-apppool-classic-net-apppool

 

  • Go into IIS Manager
  • On the node with your computer name, select "Application Pools"
  • Click "Classic .NET AppPool" and select "Advanced Settings..."
  • Select "Identity" property and change its value to "LocalSystem"

IIS