Login failed for user 'IIS APPPOOL\Classic .NET AppPool'

I just added my website to IIS. After much troubleshooting I was able to make it run with the Classic .NET App Pool.

But on the page which requires connecting with the database, I am getting the error "Login failed for the user 'IIS APPPOOL\Class .NET AppPool'

Please suggest a wor开发者_C百科karound.

Are you using integrated security in the DB connection string? if so, you either need to change the connection string to specify a username or password. or change the asp.net settings in IIS to enable impersonation, this will mean the web app is running as another specified user (you would need to ensure the alternate user has access to the database otherwise you will have the same problem!)

• 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"