JDBC Connection Failed to SQL Server: How to Troubleshoot TCP/IP Connection Problems?

JDBC Connection Failed: Troubleshooting TCP/IP Connection Issues

While attempting to establish a JDBC connection to a SQL Server 2012 database, you encountered the following error:

Error:

"The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Verify the connection properties."

This error indicates that the Java class file is unable to establish a TCP/IP connection to the SQL Server instance on the specified host and port. Here's a step-by-step guide to resolve this issue:

1. Check SQL Server Configuration:

   • Open SQL Server Configuration Manager and expand SQL Server 2012 Network Configuration.
   • Click Protocols for InstanceName and verify that TCP/IP is enabled in the right panel.
   • Double-click TCP/IP and check the Protocol tab.

2. Confirm TCP Port:

   • Note the value of the Listen All item.
   • If Listen All is set to yes, the TCP port number is the value of the TCP Dynamic Ports item under IPAll.
   • If Listen All is set to no, check the TCP Dynamic Ports item for the specific IP address you're using.
   • Ensure that the TCP port is set to 1433.

3. Update JDBC Connection String:

   • In your Java code, make sure the connection string includes the correct port number:

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

4. Firewall Considerations:

   • Ensure that the firewall does not block TCP connections to port 1433.

5. Restart SQL Server Instance:

   • Stop and restart the SQL Server instance to refresh its network settings.

By following these steps, you can successfully resolve the TCP/IP connection issue and establish the JDBC connection to your SQL Server database.

The above is the detailed content of JDBC Connection Failed to SQL Server: How to Troubleshoot TCP/IP Connection Problems?. For more information, please follow other related articles on the PHP Chinese website!