If a "Error Establishing Socket" error occurs when running the program, the following debugging should be made:
1 Check if the SQL Server is allowed to access remote access. Details:
1) Open Enterprise Manager, open the Contents of the Console> SQL Server Group> Database
2) Click Right click on the corresponding "Database" and select "Properties"
3) Select the "Connection" tab, check if the RPC service is selected under the Remote Server Connection.
2 Use the Telnet IP address 1433, whether the system prompts to connect an error, such as the system prompt error
Check if the firewall is blocked by the network access port of SQL Server or Java IDE
If so, turn off the firewall, restart SQL Server and Java IDE, test,
If the system still prompts the above error, try the following steps
3 Check the SQL Server port number and whether TCP / IP protocol is enabled, the specific steps:
1) Open Enterprise Manager, open the Contents of the Console> SQL Server Group> Database
2) Click Right click on the corresponding "Database" and select "Properties"
3) Select the General tab, click on "Network Configuration", if there is no "TCP / IP Protocol" in the enabled protocol,
4) Select "TCP / IP Protocol", click "Properties", check if its port number is 1433
5) If the port number is 1433 to modify it to other port numbers, modify the JDBC connection statement, change the port number to the newly enabled port number, such as JDBC: Microsoft: SQLServer: // Server_name: 1400 (assuming new port number is 1400)
