How do I grant permissions to ApplicationPoolIdentity in SQL Server 26 December 2013 Donovan-Brown Work (0) 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.
Web application causes An attempt was made to load a program with an incorrect format error. 23 March 2013 Donovan-Brown Work (0) Problem: When I attempt to start my asp.net web application running in IIS 8 I receive the following error: Could not load file or assembly 'Xxx' or one of its dependencies. An attempt was made to load a program with an incorrect format. Solution: Enable 32-Bit Applications for the Application Pool running your application. Explanation: Start IIS and select your web applications virtual directory under Sites\Default Web Site. Select Basic Settings from the Actions pane. Note the Application pool your application is using and click Cancel to close the dialog. Select Application Pools from the Connections pane. Right click on the application pool running your web application and select Advanced Settings from the context menu. Change Enable 32-bit Applications from False to True.
System.Security.SecurityException when connecting to remote database from IIS7 10 December 2010 Donovan-Brown Work (0) In this post I show you how to clear the Security Exception connecting to a remote database from IIS7. [More]