Have you just installed Windows 7 or Windows Server 2008 R2 and when you tried to setup your asp.net/mssql website you got following error: “Login failed for user ‘IIS APPPOOLClassic .NET AppPool‘”?
It seems that new IIS version 7.5 runs its Classic .NET AppPool process with a different identity, and from there we get error “Login failed for user ‘IIS APPPOOLClassic .NET AppPool‘”.
- go into Internet Information Services (IIS) Manager
- expand node with your computer name on left side and select “Application Pools”
- now in the window on the right side, right click “Classic .NET AppPool” and select “Advanced Settings…”
- find “Identity” property and change its value to “LocalSystem”