com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.1.26, port 1433 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.".

Stack Overflow | Manee | 4 months ago
  1. 0

    Cant Connect MSSQL server Using sqoop to Hadoop

    Stack Overflow | 4 months ago | Manee
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.1.26, port 1433 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.".
  2. 0

    Sqoop connection to MS SQL timeout

    Stack Overflow | 4 years ago | tgrosinger
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <HOST>, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
  3. 0

    Sqoop from HDInsight Cluster:Error while connecting to SQL Server 2012 - Azure HDInsight - Developer teacher

    developerteacher.com | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the ho st XX.XX.XXX.XX, port 1433 has failed. Error: "connect timed out. Verify the con nection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking T CP connections to the port.".
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Sqoop fail to import sqlserver tables. Possible to... - Cloudera Community

    cloudera.com | 7 months ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Échec de la connexion TCP/IP à l'hôte , port 1433. Erreur : « null. Vérifiez les propriétés de connexion. Assurez-vous qu'une instance de SQL Server est en cours d'exécution sur l'hôte et accepte les connexions TCP/IP au port. Vérifiez que les connexions TCP au port ne sont pas bloquées par un pare-feu. ». at com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerException.Co nvertConnectExceptionToSQLServerException(SQLServe rException.java:241)
  6. 0

    Sqoop from HDInsight Cluster:Error while connecting to SQL Server 2012

    microsoft.com | 11 months ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the ho st XX.XX.XXX.XX, port 1433 has failed. Error: "connect timed out. Verify the con nection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking T CP connections to the port.".

  1. balintn 2 times, last 2 months ago
  2. Andreas Häber 3 times, last 1 month ago
  3. abrazeneb 35 times, last 3 months ago
47 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.microsoft.sqlserver.jdbc.SQLServerException

    The TCP/IP connection to the host 192.168.1.26, port 1433 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()
  2. com.microsoft.sqlserver
    SQLServerDriver.connect
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
    2. com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)
    3. com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2280)
    4. com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:493)
    5. com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1387)
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1068)
    7. com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:904)
    8. com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:451)
    9. com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1014)
    9 frames
  3. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:571)
    2. java.sql.DriverManager.getConnection(DriverManager.java:233)
    2 frames
  4. org.apache.sqoop
    Sqoop.run
    1. org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:883)
    2. org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
    3. org.apache.sqoop.manager.CatalogQueryManager.listDatabases(CatalogQueryManager.java:57)
    4. org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:49)
    5. org.apache.sqoop.Sqoop.run(Sqoop.java:143)
    5 frames
  5. Hadoop
    ToolRunner.run
    1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
    1 frame
  6. org.apache.sqoop
    Sqoop.main
    1. org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
    2. org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
    3. org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
    4. org.apache.sqoop.Sqoop.main(Sqoop.java:236)
    4 frames