com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]

by

You need to go to
Start > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager

When it opens, go to SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLExpress.

There you’ll find the Protocol TCP/IP, if disabled then Enable it. Click on TCP/IP, you’ll find its properties.

In these properties, remove all the TCP Dynamic Ports and add value of 1433 to all TCP ports, and restart your SQL Server Services > SQL Server

And it’s done.

More Related Contents:

  1. How do I connect to a SQL Server 2008 database using JDBC?
  2. Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
  3. How to pass Table-Valued parameters from java to sql server stored procedure?
  4. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  5. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  6. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  7. How to establish a connection pool in JDBC?
  8. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  9. Cannot issue data manipulation statements with executeQuery()
  10. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  11. JDBC Class.forName vs DriverManager.registerDriver
  12. IO Error: The Network Adapter could not establish the connection
  13. java.sql.SQLException: Column count doesn’t match value count at row 1
  14. How to call oracle stored procedure which include user-defined type in java?
  15. Java JDBC Access denied for user [closed]
  16. Why does autoReconnect=true not seem to work?
  17. How does Class.forName() work?
  18. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  19. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  20. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  21. MySQL connector error “The server time zone value Central European Time” [duplicate]
  22. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  23. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  24. Connection cannot be cast to oracle.jdbc.OracleConnection
  25. How to map a ResultSet with unknown amount of columns to a List and display it in a HTML table?
  26. NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver
  27. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  28. MyBatis executing multiple sql statements in one go, is that possible?
  29. A persistent connection with JDBC to MySQL
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment