title: all pooled connections were in use and max pool size was reached
body: <p>I am writing a .NET 4.0 console app that </p>
  
  <ol>
  <li>Opens up a connection Uses a Data Reader to cursor through a list of keys <P></li>
  <li>For each key read, calls a web service <P></li>
  <li>Stores the result of a web service in the database <P> </li>
  </ol>
  
  <p>I then spawn multiple threads of this process in order to improve the maximum number of records that I can process per second.</p>
  
  <p>When I up the process beyond about 30 or so threads, I get the following error:</p>
  
  <pre><code>System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.   This may have occurred because all pooled connections were in use and max pool size was reached.
  </code></pre>
  
  <p>Is there an Server or client side option to tweak to allow me to obtain more connections fromn the connection pool?</p>
  
  <p>I am calling a sql 2008 r2 DATABASE.</p>
  
  <p>tHx</p>