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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s