com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host XXXX, port 1434 has failed. Error: "connect timed out. 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.".

tip

If you're not using yet, consider using the SQLServerDataSource to set your server configurations. Also, check if the server is accepting TCP/IP connections and if there's no firewall blocking the connections.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Java y Sql Server
    via by Unknown author,
  • SQL Server jdbc connection
    via Stack Overflow by yatinbc
    ,
  • MS SQL WITH JAVA
    via Stack Overflow by Korken55
    ,
  • How to create DB indexing
    via GitHub by srinivasv2
    ,
  • Connect JAVA with SQLEXPRESS
    via Stack Overflow by Anubis
    ,
    • com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host XXXX, port 1434 has failed. Error: "connect timed out. 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.". at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241) at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243) at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) at com.ataccama.dqc.commons.sql.util.SimpleDataSource.getConnection(SimpleDataSource.java:86) at com.ataccama.dqc.internal.commons.sql.AtcDataSource.getConnection(AtcDataSource.java:46) at com.ataccama.dqc.commons.sql.util.SimpleDataSource.getConnection(SimpleDataSource.java:70) at com.ataccama.dqc.internal.commons.sql.AtcDataSource.getConnection(AtcDataSource.java:41) at com.ataccama.dqc.commons.sql.DataSourceImpl.getRawConnection(DataSourceImpl.java:96) at com.ataccama.dqc.commons.sql.DataSourceImpl.getNonTransactionalConnection(DataSourceImpl.java:64) at com.ataccama.dqc.gui.ui.wizards.database.DatabaseConnectionModel.testConnection(y:954) at com.ataccama.dqc.gui.ui.wizards.database.NewDatabasePage$1.run(y:1147) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

    Users with the same issue

    SteVio1989
    SteVio19892 times, last one,
    Andreas Häber
    Andreas Häber3 times, last one,
    musketyr
    musketyr1 times, last one,
    balintn
    balintn2 times, last one,
    Unknown visitor1 times, last one,
    110 more bugmates