title: SQL Server trusted connection has wrong user in IIS, but SSMS is OK
body: <p>I am using VS 2012, connecting to SQL Server 2008 host using windows credentials. I can connect fine from Management Studio, but when I run a web application (IIS 7.5 windows 7 ASP.NET 4.0 integrated) and my application tries to connect, I get this:</p>
  
  <blockquote>
    <p>Login failed for user 'MyDomain\MyMachineName$'.</p>
  </blockquote>
  
  <p>For some reason IIS App pool using Network Identity is not using MyUserName but my machine name instead.  My connection string is:</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;clear /&gt;
      &lt;add name="Assignment" 
           connectionString="Data Source=a.b.c.d;Initial Catalog=My_Db;Trusted_Connection=true;Max Pool Size=200;Pooling=True;" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I should mention this is a new (to me) computer. I looked in credential manager and there is nothing there. Any ideas why IIS and my web app using the wrong thing?</p>