Login failed for user ‘IIS APPPOOL\DefaultAppPool’.[EkSite->GetSiteVariables()]

As I have mentioned earlier, I started playing around with the Ektron 400 CMS.NET content management system. Soon after I installed starter kit websites, I got the below error.

Login failed for user 'IIS APPPOOL\DefaultAppPool'.[EkSite->GetSiteVariables()]

My system configuration is Windows 7 x64, IIS 7, .NET 3.5, SQL 2008 (with NT Authentication) and Ektron 7.6.6. If you got that error, this one could be your fix. Continue reading