IIS Application Pool Identity Accounts

This is mostly one of those notes to self, but when develops a WCF service that accesses a database then you make sure that the account the IIS process is running under has rights to the database. There are built in accounts for the appPools that your service is running in. eg if I assign my FOO app to ASP.NET v4.0 pool then there is a default account IIS APPPOOL\ASP.NET v4.0 that is created for us. This is the account that we need to add to User list in SQL Management Studio for the database that FOO is accessing e.g TrafficCams.




For a more complete description see