How do I grant permissions to ApplicationPoolIdentity in SQL Server


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


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.

Comments are closed