The TCP/IP connection to the host localhost, port 1433 has failed

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

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

In this properties Remove All the TCP Dynamic Ports and Add value of 1433 to all TCP Port
and restart your SQL Server Services > SQL Server

And Its Done…

More Related Contents:

  1. JDBC connection failed, error: TCP/IP connection to host failed
  2. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  3. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  4. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  5. How do I connect to a SQL Server 2008 database using JDBC?
  6. 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
  7. JPA SQL Server No Dialect mapping for JDBC type: -9
  8. Native Library sqljdbc_auth.dll already loaded in another classloader
  9. Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
  10. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  11. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  12. How to pass Table-Valued parameters from java to sql server stored procedure?
  13. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  14. How to get *everything* back from a stored procedure using JDBC
  15. Getting the Return Value from JDBC MSSQL
  16. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  17. How to connect to a remote MySQL database with Java?
  18. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR
  19. java.util.Date vs java.sql.Date
  20. Can we connect remote MySQL database in Android using JDBC? [closed]
  21. JDBC MySql connection pooling practices to avoid exhausted connection pool
  22. Countdowntimer in minutes and seconds
  23. Maven dependencies not visible in WEB-INF/lib
  24. Queries returning multiple result sets
  25. Eclipse: enable assertions
  26. Eclipse + Java 8 support?
  27. UnsupportedClassVersionError: JVMCFRE003 bad major version in WebSphere AS 7
  28. When my app loses connection, how should I recover it?
  29. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  30. How do I enable index downloads in Eclipse for Maven dependency search? [duplicate]

Leave a Comment