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

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

Solution: Multiple Issues i had while trying to connect to SQL Server

1.

sqljdbc4.jar class library provides support for JDBC 4.0. It includes all of the features of the sqljdbc.jar as well as the new JDBC 4.0 methods.

sqljdbc4.jar class library requires a Java Runtime Environment (JRE) of version 6.0 or later. Using sqljdbc4.jar on JRE 1.4 or 5.0 will throw an exception.

Note

Use sqljdbc4.jar when your application must run on JRE 6.0, even if your application does not use JDBC 4.0 features.

2.

sqljdbc.jar class library provides support for JDBC 3.0.

sqljdbc.jar class library requires a Java Runtime Environment (JRE) of version 5.0. Using sqljdbc.jar on JRE 6.0 will throw an exception when connecting to a database.

Note

The JDBC Driver does not support JRE 1.4. You must upgrade JRE 1.4 to JRE 5.0 or later when using the JDBC Driver0. In some cases, you might need to recompile your application because it might not be compatible with JDK 5.0 or later. For more information, see the documentation on Sun Microsystems Web site.

sqljdbc4 can  be downloaded from http://www.mediafire.com/?3ycmaelhoot

2. Add one of the above jars to your classpath

3. Copy sqljdbc_auth.dll from the enu\auth\x86 folder of jdbc to C:\Windows\System32

3. Check the SQL Server port on which it is running from SQL Server Management Studio ->Management -> SQL Server Logs > Current