title: Cannot connect to Database with Entity Framework
body: <p>Every time I have a fresh install of Windows, Visual Studio and Sql Server I always have problems getting an application to connect to the local instance of Sql Server.</p>
  
  <p>I am trying to start an application using Entity Framework code first.  Here is my connection string.</p>
  
  <pre><code>&lt;add name="KCSoccerDataContext" 
       connectionString="Data Source=.\MSSQLSERVER;Initial Catalog=KCSoccer;Integrated Security=SSPI" 
       providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>I am able to connect to the database instance using Sql Server Management Studio, but can't seem to connect using this connection string.  I am assuming the problem has to do with how the database instance is configured.</p>
  
  <p>The error I'm getting is </p>
  
  <blockquote>
    <p>{"The provider did not return a ProviderManifestToken string."}</p>
  </blockquote>
  
  <p>I'm not exactly sure what this means or where to go from here.</p>
  
  <p>Any help anyone could give on this would be awesome.</p>
  
  <p>Thanks</p>