title: SQL Server Asp.Net - "Login failed"
body: <p>I can't get my Asp.Net application to work on a server I'm deploying to. The server is running Server 2008 R2, and I am running SQL Server 2008 R2 Express on top of that. When I browse to the site I get error</p>
  
  <blockquote>
    <p>Login failed for user 'WIN-6VLI5UDJ5RN\Lappearn'</p>
  </blockquote>
  
  <p>I have tried creating the account both in SQL Server and on the server itself but made no difference. Here is my connection string</p>
  
  <pre><code>Data Source=localhost\SQLExpress;Initial Catalog=Lappearn;User ID=WIN-6VLI5UDJ5RN\Lappearn;Password=password;
  </code></pre>
  
  <p>The SQL Server is now running both Windows and SQL Server auth mode.</p>