SqlException: Login failed for user ‘IIS APPPOOL

This issue is related with the permission for application pool to connect with the sql.
We can create login user with the name as specified in the exception IIS APPPOOL<name>
and grant permission to the database.
We can create new login user by opening the SSMS(Sql server management studio) navigate to Security>Login 
Then Add the user by right clicking Login and selecting new login
While creating user Navigate to UserMapping and tick the database for the specific user.

This process will create the new user and gran permission to the user.

Another Work Around
Yet another simple way will be to change the application pool Identity property To LocalSystem by navigating to the application pool and then advance setting.

Leave a Reply

Your email address will not be published. Required fields are marked *