title: Granting sql server database access to IIS APPPOOL\DefaultAppPool
body: <p>I have an ASP NET APP that's trying to access a sql server database, when I run it, I get an error saying </p>
  
  <blockquote>
    <p>"Login Failed for user IIS <strong>APPPOOL\DefaultAppPool</strong>"</p>
  </blockquote>
  
  <p>Searching the web I found that I should grant access to this user, so I executed the following script:</p>
  
  <pre><code>grant  execute on schema :: dbo to [IIS APPPOOL\DefaultAppPool]
  </code></pre>
  
  <p>It executed succesfully as a script for my database, but I still get the <code>"Login Failed"</code> error.</p>
  
  <p>What's missing?</p>