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 | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Cant Connect MSSQL server Using sqoop to Hadoop

    Stack Overflow | 8 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 | 2 years 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 | 10 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 | 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.".
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