java.lang.RuntimeException: 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 | 7 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 | 7 months ago | Manee
    java.lang.RuntimeException: 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 and MSSQL with window auth on linux fails

    Stack Overflow | 2 years ago | Karan
    java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'username'. ClientConnectionId:a593dc10-2d06-4b8b-b53b-e743fb133d0e
  3. 0

    Java y Sql Server

    el-hacker.com | 2 years ago
    com.microsoft.sqlserver.jdbc.SQLServerException: No se pudo realizar la conexión TCP/IP al host (aqui muestra mi servidor o mi ip), puerto 1433. Error: "Connection refused: connect. Verifique las propiedades de conexión, compruebe que hay una instancia de SQL Server ejecutándose en el host y aceptando las conexiones TCP/IP en el puerto y compruebe que no hay ningún firewall bloqueando las conexiones TCP en el puerto.".
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to connect to MSSQL Server 2012 using sqljdbc4.jar

    Stack Overflow | 3 years ago | Leejoy
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'admin'. ClientConnectionId:1530f396-0935-4c41-92f1-016797a65edd
  6. 0

    SQL Server jdbc connection

    Stack Overflow | 4 years ago | yatinbc
    com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. 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.".
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