title: ASP/SQL Server Express: Could not open a connection to SQL Server [53]
body: <p>Windows 7, IIS 7.5, SQL Server 2008 R2, ASP classic (website I want to upgrade, but need to make it works).</p>
  
  <p>connection string: </p>
  
  <pre><code>Provider=SQLNCLI10; Data Source=.\SQLExpress; Initial Catalog=shoshvi_sql-db;Integrated Security=SSPI;Connect Timeout =1
  </code></pre>
  
  <p>I am getting this annoying error:</p>
  
  <blockquote>
    <p>Microsoft SQL Server Native Client 10.0  '80004005' </p>
    
    <p>Named Pipes Provider: Could not open a connection to SQL Server [53]. </p>
    
    <p>filename.asp, line 15</p>
  </blockquote>
  
  <p>What I tried, as I remember:</p>
  
  <ul>
  <li>Test connection using SSMS (works, to localhost and to other server in LAN)</li>
  <li>Test connection using SQLCMD (works, to localhost and to other server in LAN)</li>
  <li>Tried  many datasources/servers ( <code>name\SQLExpress</code>, <code>.\SQLExpress</code>, .\SQLEXPRESS)</li>
  <li>Tried to change settings in Start Menu\Programs\Microsoft SQL Server 2008\Configuration Tools, enable TCP/IP, Named Pipes, look all sub items and find wrong configuration.
  after any change, I was restarted service.</li>
  <li>Tried to enable SQL Server Browser.</li>
  <li>Tried to connect to other SQL Server in the same network, using SA and SA password (in the other "server" I could use IIS/ASP/MSSQL and works fine).</li>
  <li>Tried to disable Windows Firewall</li>
  <li>Tried to enable remote connections to SQL Server Express</li>
  <li>Tried  Integrated Security=SSPI</li>
  <li>Tried Windows Administrator password</li>
  <li>Tried change to TCP/IP (and get other error, same reason)</li>
  <li>Tried to search google, and stackOverflow and other for an idea.</li>
  <li>Tried similar questions here.</li>
  </ul>
  
  <p>What more?</p>
  
  <p>Thanks !</p>