title: provider named pipes provider error 40 - could not open a connection to sql server 2008
body: <p>SQL Server Name : <code>ECARE432</code><br>
  Instance Name : <code>SQLEXPRESS</code></p>
  
  <p><code>app.config</code> contains:</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;connectionStrings&gt;
     &lt;add name="TimeTracker.Properties.Settings.myecareConnectionString"  
          connectionString="Data Source=ECARE432;Initial Catalog=myecare;Persist Security Info=True;User ID=sa;Password=ecare123@" 
          providerName="System.Data.SqlClient"/&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I have developed my first application in WPF (C#) with VS 2008 &amp; SQL Server 2008. It works fine on my system. After deployment, it doesn't work on other systems. </p>
  
  <p>It shows the following error message.</p>
  
  <blockquote>
    <p>provider named pipes provider error 40 - could not open a connection to sql server 2008</p>
  </blockquote>
  
  <p>I have gone through Google and done the following steps but no use. </p>
  
  <ol>
  <li>Configuration Tools -> SQL Server Configuration Manager -> SQL Native Client Configuration Aliases -> Alias Name -> ECARE432,1433, Port Number -> 1433, Protocol -> TCP/IP, Server Name -> ECARE432</li>
  <li>TCP/IP is enabled. Protocols -> TCP/IP Properties -> IP1 -> Active - Yes Enabled - Yes, IP Address - My system IP address, TCP Dynamic Ports - Blank, TCP Port - 1433
  <ul>
  <li>IP2 -> Active - Yes, Enabled - Yes, IP Address - 127.0.0.1, TCP Dynamic Ports - Blank, TCP Port - 1433</li>
  <li>IPALL -> TCP Dynamic Ports - Blank, TCP Port - 1433</li>
  </ul></li>
  <li>SQL Server Browser is running.</li>
  <li>Server Name is correct. No typo mismatch.</li>
  <li>Client machine is able to ping my machine. (<code>PING ECARE432</code> is working)</li>
  <li>TCP 1433 and UDP 1434 Exception added to Firewall. Also Turned off the Firewall in both my system and the client system.</li>
  <li><code>sqlbrowser.exe</code> is added to the Firewall Exception List.</li>
  <li>Allow Remote Connections enabled under Connections in SQL Server Properties.</li>
  <li>Visual Studio --> Tools --> Options --> Database Tools --> Data Connections --> Changed "SQL Server Instance Name" from <code>sqlexpress</code> to blank.</li>
  </ol>
  
  <p>Please guide me how to fix this issue.</p>