title: Error establishing socket
body: <p>Have a java program which is trying to insert about 150k records to sql server database and failing with the error below. </p>
  
  <blockquote>
    <p>[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket</p>
  </blockquote>
  
  <p>Started seeing these errors after the increase in data volume i.e the number of inserts. The SQL Server connection works works fine.</p>
  
  <p>I tried changing the JDBC string by setting Max connection pool as below</p>
  
  <pre><code>String DB_URL= "jdbc:sqlserver://xxx.com:11111;SelectMethod=Direct;DatabaseName=DB1;Max Pool Size=100000"
  </code></pre>
  
  <p>Not sure how to fix this issue. Please need help on the same.</p>