JDBC connection failed, error: TCP/IP connection to host failed

by
  1. Open SQL Server Configuration Manager, and then expand SQL Server 2012 Network Configuration.
  2. Click Protocols for InstanceName, and then make sure TCP/IP is enabled in the right panel and double-click TCP/IP.
  3. On the Protocol tab, notice the value of the Listen All item.
  4. Click the IP Addresses tab:
    If the value of Listen All is yes, the TCP/IP port number for this instance of SQL Server 2012 is the value of the TCP Dynamic Ports item under IPAll.
    If the value of Listen All is no, the TCP/IP port number for this instance of SQL Server 2012 is the value of the TCP Dynamic Ports item for a specific IP address.
  5. Make sure the TCP Port is 1433.
  6. Click OK.

More Related Contents:

  1. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  2. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  3. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  4. How do I connect to a SQL Server 2008 database using JDBC?
  5. SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  6. JPA SQL Server No Dialect mapping for JDBC type: -9
  7. Native Library sqljdbc_auth.dll already loaded in another classloader
  8. Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
  9. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  10. How to pass Table-Valued parameters from java to sql server stored procedure?
  11. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  12. How to get *everything* back from a stored procedure using JDBC
  13. Getting the Return Value from JDBC MSSQL
  14. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  15. The TCP/IP connection to the host localhost, port 1433 has failed
  16. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR
  17. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  18. How to establish a connection pool in JDBC?
  19. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  20. How to map an entity field whose name is a reserved word in JPA
  21. ResultSet exception – before start of result set
  22. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  23. java.sql.SQLException: Column count doesn’t match value count at row 1
  24. How often should Connection, Statement and ResultSet be closed in JDBC?
  25. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  26. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  27. MySQL connector error “The server time zone value Central European Time” [duplicate]
  28. Different representation of UUID in Java Hibernate and SQL Server
  29. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  30. Database independence through JDBC in java

Leave a Comment