title: IIS 7.5 front end with SQL Server 2008 R2 back end. How to use app pool domain account to connect to SQL
body: <p>Ok, I noticed a lot of questions close to what I am doing, but none of them seem to handle what I am looking for. </p>
  
  <p>Here is what I am trying to do.  I have two servers on say the happy domain.  One being IIS 7.5 and the other being SQL Server 2008 R2. Both being windows 2008 R2 server on the happy domain. The application is called <code>newapp</code> and the application pool is <code>newpool</code></p>
  
  <p>I created an active directory account called <code>app1</code> on the happy domain. </p>
  
  <p>I put <code>happy/app1</code> in application pool identity for the app pool <code>newpool</code>. I give it access to the server and I give it DBA owner access to the SQL Server database.</p>
  
  <p>Developers have integrated security set to true and sspi. Shouldn't that make it use the <code>apppool</code> account to connect to the SQL Server database?</p>
  
  <p>At the moment I get <code>System.Data.SqlClient.SqlException</code>: </p>
  
  <blockquote>
    <p><em>Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON</em></p>
  </blockquote>
  
  <p>Thanks.</p>