title: .NET web app cant run SQL queries
body: <p>I have a website on a laptop to show a client, the laptop has IIS 6 and SQL Server 2008, the same set up as my development pc.
  Although everything work fine on the dev pc I can't get the site to run queries against SQL.</p>
  
  <p>It will show data in dropdowns, but when I try to run queries I get an error which looks as if the connection string is wrong, which I don't think it is.  Ive been trying for a week to sort this, Ive tried all the SQL config changes, named pipes, using NT AUTHORITY\network service user for the app pool, and a few things beside.  Is there anything anyone else has heard of to sort this?  Or anything else I could check?</p>
  
  <p>my web config connection string</p>
  
  <pre><code>&lt;add name="eisConnectionString" 
      connectionString="data source=lapgha11863\sqlexpress;Initial Catalog=eis;Integrated Security=True" 
      providerName="System.Data.SqlClient"/&gt;
  </code></pre>
  
  <p>and the error returned from .NET</p>
  
  <blockquote>
    <p>"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: Named
    Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    "</p>
  </blockquote>