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.