title: My computer cannot connect through JDBC to SQL Server 2012 (times out) while others can
body: <p>So basically, I'm having trouble connecting to SQL Server 2012 through JDBC through my tomcat web application and also SQuirreL</p>
  
  <p>I've tried substituting multiple versions of sqljdbc jar files. The weird thing is, my co-worker is able to successfully connect!</p>
  
  <p>Also, all jars successfully connect to a different SQL Server 2005.</p>
  
  <p>SQL Server Management Studio 2005 express (on my machine) connects to both SQL Server 2005 &amp; 2012 without issue.</p>
  
  <p>Tomcat Resource setting:</p>
  
  <pre><code>&lt;Resource auth="Container" description="a Database Connection" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" logAbandoned="true" maxActive="300" maxIdle="50" maxWait="10000" name="jdbc/SomethingPool" password="PW" removeAbandoned="true" removeAbandonedTimeout="60" type="javax.sql.DataSource" url="jdbc:sqlserver://&lt;SOMETHING&gt;.&lt;DOMAIN&gt;.com:1433;databaseName=dbname;" username="USER"/&gt;
  </code></pre>
  
  <p>old SQL JDBC version (sorry, don't know how to check versions): </p>
  
  <ul>
  <li>SQuirreL test connect- times out</li>
  <li>SQuirreL connect - times out</li>
  <li>Tomcat - times out</li>
  <li>other developer SQuirreL - SUCCESS!</li>
  <li>other developer Tomcat - SUCCESS!</li>
  <li>SQL Server 2005 SQuirreL - SUCCESS!</li>
  </ul>
  
  <p>new SQL JDBC version (downloaded recently from <a href="http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx</a>):</p>
  
  <ul>
  <li>SQuirreL test connect- SUCCESS! <em>also weird</em></li>
  <li>SQuirreL connect - times out</li>
  <li>Tomcat - com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.</li>
  <li>other developer SQuirreL - N/A</li>
  <li>other developer Tomcat - N/A</li>
  <li>SQL Server 2005 SQuirreL - SUCCESS!</li>
  </ul>
  
  <p>My machine</p>
  
  <ul>
  <li>Windows 7</li>
  <li>SQuirreL 3.5.0</li>
  <li>Tomcat 6.0.18</li>
  <li>Java 1.6.0_29</li>
  <li>connection string: jdbc:sqlserver://..com:1433</li>
  <li>SQL Server Management Studio Express 2005</li>
  </ul>
  
  <p>Server:</p>
  
  <ul>
  <li>Windows Server 2012 R2</li>
  <li>SQL Server 2012 (2005 compatibility)</li>
  </ul>
  
  <p>Old Server:</p>
  
  <ul>
  <li>Windows Server 2003 R2</li>
  <li>SQL Server 2005</li>
  </ul>
  
  <p>Thanks!</p>