Login failed for user ‘IIS APPPOOL\AppPoolName’

Applicationb Pool configuration
2014-05-28_11h52_18

Error message from applicaiton

Cannot open database "My_database" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\AppPoolName'.

Solution

To fix it you have to add new login to your SQL Server

  • In SQL Server Management Studio find the Security folder
  • Right click logins and select “New Login”
  • In the Login name field, type IIS APPPOOL\AppPoolName – do not click search
  • Click OK