Login failed for user ‘IIS APPPOOL\AppPoolName’

Applicationb Pool configuration

Error message from applicaiton

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


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