Problem:

My IIS Application Pool is using ApplicationPoolIdentity and does not have permissions to my SQL Server database.

Solution:

Open Sql Server Management Studio (SSMS) and create a new login for "IIS AppPool\{YourAppPoolNam}".  On the User Mapping page give the user access to the database and save and close the dialog.