title: jdbc sql server connection error on dev server
body: <p>I am using tomee, JPA and find below the configuration:</p>
  
  <p>tomee.xml:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;tomee&gt;
      &lt;Resource id="dataSource" type="DataSource"&gt;
           JdbcDriver com.microsoft.sqlserver.jdbc.SQLServerDriver
           JdbcUrl jdbc:sqlserver://******:1433;databaseName=******
           UserName ******
           Password ******
           JtaManaged true
      &lt;/Resource&gt;
  &lt;/tomee&gt;
  </code></pre>
  
  <p>persistence.xml:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;persistence xmlns="http://java.sun.com/xml/ns/persistence" 
               xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
               xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" 
               version="1.0"&gt;
     &lt;persistence-unit name="app"&gt;
        &lt;provider&gt;org.hibernate.ejb.HibernatePersistence&lt;/provider&gt;
        &lt;jta-data-source&gt;dataSource&lt;/jta-data-source&gt;
        &lt;properties&gt;
           &lt;property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/&gt;
           &lt;property name="hibernate.show_sql" value="false"/&gt;
           &lt;property name="hibernate.format_sql" value="false"/&gt;
        &lt;/properties&gt;
      &lt;/persistence-unit&gt;
  &lt;/persistence&gt;
  </code></pre>
  
  <p>This is working fine on my local. But when I tried to deploy my application to Dev Linux server, I am getting this exception <code>WARN: HHH000342: Could not obtain connection to query metadata : The TCP/IP connection to the host ******, port 1433 has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".</code></p>
  
  <p>The only difference is localhost is windows machine and dev server is Linux machine. As far as I know for this there are no changes required in connection string except the host name.</p>
  
  <p>I also tried with DB server IP address instead of host name. Now server is stuck at this point: <code>INFO: HHH000130: Instantiating explicit connection provider:org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider</code></p>
  
  <p>Please give your suggestions.</p>