title: Error connecting SQL server to MVC3 application - A network-related or instance-specific error
body: <p>I'm getting this error since I've moved my mvc3/entity framework site onto the live server from localhost.  Normally when I would get this error, I'd check the database name, password and server are all correct in the connection string.  I have checked this - they all seem fine.</p>
  
  <p>I have aspnet Membership provider on the site within the database, and it allows me to login, verifies me, then tries to redirect me to another page, and then that's where the error happens - i.e., as soon as I connect to the database outwith the membership provider.</p>
  
  <p>The database is on the same server as the site, and when I connect from localhost to the remote server, it works perfectly.  </p>
  
  <p>Here is the full error message: </p>
  
  <pre><code>Exception message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
  </code></pre>
  
  <p>Here is the connection string:</p>
  
  <pre><code>&lt;add name="ApplicationServices" connectionString="Data Source=192.168.1.43;Initial Catalog=BlueLadder;User Id=BlueLadderAdmin;Password=Auth1991;timeout=30" /&gt;
  </code></pre>
  
  <p>Anyone anything I could try?</p>