How to Fix \'TCP/IP Connection to Host Failed\' Error When Connecting Java to SQL Server 2012?

JDBC Connection Error: TCP/IP Connection Failure

When attempting to establish a Java-based connection to a SQL Server 2012 database, a common error faced is the "TCP/IP connection to host failed" message. To resolve this issue, it is crucial to ensure proper configuration on both the client and server sides.

Solution:

1. SQL Server Configuration:

   a. Open SQL Server Configuration Manager.
   b. Expand SQL Server 2012 Network Configuration.
   c. Right-click Protocols for InstanceName and select Enable.
   d. Verify that the Listen All value is set to yes.
   e. Click the IP Addresses tab.
   f. If Listen All is set to yes, the port number will be displayed under IPAll.
   g. If Listen All is set to no, find the port number associated with the specific IP address.
   h. Ensure that the TCP Port is set to 1433.
   i. Click OK.

2. Java Code Optimization:

   a. Rectify the connection string in the Java code.
   b. Specify the port number in the connection URL.

Example:

String connectionUrl = "jdbc:sqlserver://127.0.0.1:1433;databaseName=aysha";
Connection con = DriverManager.getConnection(connectionUrl, "user=sa", "password=admin");

3. Firewall Settings:

   a. Ensure that your firewall is configured to allow incoming TCP connections on port 1433.
   b. Add the SQL Server process to the firewall exception list.

4. Server Status:

   a. Confirm that SQL Server is running and accepting TCP/IP connections.
   b. Check if the SQL Server service is started.

After completing these steps, you should be able to establish a successful connection between your Java class file and the SQL Server database.

The above is the detailed content of How to Fix \'TCP/IP Connection to Host Failed\' Error When Connecting Java to SQL Server 2012?. For more information, please follow other related articles on the PHP Chinese website!