title: Entity Framework using an incorrect connection string
body: <p>I try to connect to my database(which is recently moved to another server) with EF.</p>
  
  <p>Server name is :SERVER-PC</p>
  
  <p>Version of MSSQL : Microsoft SQL Server 2014 - 12.0.2000.8 </p>
  
  <p>The instance name when I get it using xp_regread sp: MSSQL12.MSSQLSERVER</p>
  
  <p>I want to ad both instance name , and server name in connection string. 
  this is my connectionstring which I got help from <a href="https://msdn.microsoft.com/en-AU/library/ms156450.aspx" rel="nofollow">this link</a></p>
  
  <pre><code>&lt;add name="DefaultConnection" connectionString="data source= SERVER-PC\MSSQL12.MSSQLSERVER; Initial Catalog=FoodDB;Integrated Security=True" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>but when I run the project , this error happens:</p>
  
  <blockquote>
    <p>error : {"The provider did not return a ProviderManifestToken
    string."}</p>
    
    <p>An error occurred while getting provider information from the
    database. This can be caused by Entity Framework using an incorrect
    connection string. Check the inner exceptions for details and ensure
    that the connection string is correct.</p>
  </blockquote>
  
  <p>Could anyone please give me a help?</p>
  
  <p><em>Note: I want to use both server name and Instance name (intentionally) in connection string. (assume the instance is not default)</em></p>