title: Difference between these connection strings?
body: <p>Can anybody tell me the effective difference between the following connection strings:</p>
  
  <pre><code>&lt;add key="ConnectionString" value="server=tcp:192.168.0.12\Sqlserver2005;database=;user id=sa;password=;"&gt;
  
  
  
  &lt;add key="ConnectionString" value="server=192.168.0.12\Sqlserver2005;database=;user id=sa;password=;Network Library=DBMSSOCN;"&gt;
  </code></pre>
  
  <p>I believe both are effectively the same. Specifying "Network Library=DBMSSOCN" explicitly connects using TCPIP and prefixing server value with TCP does the same thing.</p>
  
  <p>Please tell me if there is any difference or any performance implication of specifying these settings in web.config.</p>