title: SQL Server 2012 Connection String
body: <p>I have just installed 2012 SQL Server. All went well..</p>
  
  <p>SQL Server 2012 is installed as the default instance as the client was running on an SQL Express 2008 edition. <br></p>
  
  <p>Enabled using SQL Config manager Named Pipes Protocol as it defaults to Dis-abled. <br></p>
  
  <p>Remote Connections is checked on in SQL Server by default and double checked it was on.</p>
  
  <p>Stopped and Started the service</p>
  
  <p>Then tried to launch the client application which worked fine on 2008 R2, but it keeps failing to connect.. I have tried an array of things in the conection string including the usual (local), localhost, the IP Address... etc.</p>
  
  <p>I keep getting the same standard error: Database Error 2 ensure remote connections is enabled and the instance name is correct blah: Named Pipes provider error 40. </p>
  
  <p>here is the connection string that is being used; </p>
  
  <pre><code>connectionString="Data Source=(local);InitialCatalog=AssetManager;
  Persist Security Info=True;User ID=sa;Password=blah" providerName="System.Data.SqlClient"
  </code></pre>
  
  <p>Is there something different in 2012 that needs to added to the connection string ? what am i missing, have checked on-line, nothing obvious to find...</p>