title: Web.config Windows Authentication problems
body: <p>In web.config of my ASP.NET project, the Windows Authentication Mode (of SQL Server) is enabled ( i.e.</p>
  
  <pre><code>&lt;authentication mode="Windows"&gt;&lt;/authentication&gt;
  </code></pre>
  
  <p>). But each time when I built the project and launched it in my browser, an error appeared saying that:</p>
  
  <blockquote>
    <p>"Server Error in '/' Application Login failed for user 'DOMAIN\MS-AUTO1$'.". </p>
  </blockquote>
  
  <p>In the yellow page, the exception says "Exception Details:</p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlException: Login failed for user
    'DOMAIN\MS-AUTO1$'."</p>
  </blockquote>
  
  <p>My account shall be DOMAIN\MyAccount but not DOMAIN\MS-AUTO1$. </p>
  
  <p>How do I need to modify the web.config file so that it uses DOMAIN\MyAccount to do authentication but not DOMAIN\MS-AUTO1$ ?</p>
  
  <p>PS: 
  In Microsoft SQL Server 2012 Management Studio I use "MS-AUTO1" as the server name and Windows Authentication as the Authentication method. The Server type is Data Engine. And that works.</p>
  
  <p>Is it a reason that MS-AUTO1$ was used as my Windows username?</p>
  
  <p>Thanks</p>