title: ASP.NET MVC code-first database to SQL Server Express login failure using Entity Framework
body: <p>I am trying to generate a SQL Server database in SQL Server Express using   Entity Framework code-first.</p>
  
  <p>I am getting a login error:</p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlException was unhandled by user code<br>
    Class=14<br>
    ErrorCode=-2146232060<br>
    HResult=-2146232060<br>
    LineNumber=65536<br>
    Message=Login failed for user 'ANDECOLAPTOP2\paultherrien'.<br>
    Number=18456<br>
    Procedure=""<br>
    Server=\.\pipe\0B36D920-CE4F-4E\tsql\query<br>
    Source=.Net SqlClient Data Provider<br>
    State=1</p>
  </blockquote>
  
  <p>I am curious about this: "Server=\.\pipe\0B36D920-CE4F-4E\tsql\query", this does not appear to be a reference to my SQL Server.</p>
  
  <p>Note: My login works fine in SQL Server Management Studio.  Also, when I use the SQL client in VS the SQL Server connects and I can run queries w/o issue.</p>
  
  <p>This is what I have in my <code>web.config</code> for the connection string:</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="ISkillsContext" 
           connectionString="data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\ISkillsDb.mdf;integrated security=true;user instance=True;multipleactiveresultsets=True;" 
           providerName="System.Data.SqlClient" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I am following a video tutorial and have emailed the author for help and have searched everywhere for ideas. </p>
  
  <p>I am using VS 2015 Community Edition and SQL Server 2014 Express.</p>
  
  <p>Thanks in advance.</p>
  
  <p>Paul</p>