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
Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s