title: How do I configure SQL Server to allow access via IIS
body: <p>I have a web service that stores data in a local SQL Server 2008 database. If I run the web service under my account the web service can successfully access the database. However, if  I use the DefaultAppPool (IUSR) account then accessing the database from the web service fails.</p>
  
  <p>How do I set security on SQL Server to allow access to a specific database via IIS?</p>
  
  <p>The specific error message I am getting is:
  Login failed for user 'IIS APPPOOL\DefaultAppPool'</p>