title: SQL Server communication protocol issue
body: <p>I am using VSTS 2008 + C# + ADO.Net + SQL Server 2008. My questions about what kinds of communication protocols SQL Server 2008 will be using, more details of my questions,</p>
  
  <ol>
  <li><p>If the connection string looks like this, whether Named Pipe or TCP/IP is used? Will different communication protocol being used dependent on whether client and SQL Server on the same machine?</p>
  
  <p>Data Source=labtest1;Initial Catalog=CustomerDB;Trusted_Connection=true;Asynchronous</p></li>
  <li><p>In SQL Server Configuration Manager, there are items called "SQL Server Network Configuration" and "SQL Native Client 10.0 Configuration". I find both of them has configuration options (for communication protocols) of Named Pipe or TCP/IP, what are the differences between "SQL Server Network Configuration" and "SQL Native Client 10.0 Configuration"?</p></li>
  </ol>