JDBC configuration statement is: JDBC: Microsoft: SQLServer: // Server_Name: 1433
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 Confinder root directory> SQL Server group> Database 2) On the corresponding "Database", right-click, select "3) Select" Connect "tab, check" Remote server connection "Under the RPC service is selected.
2 Use Telnet IP Address 1433, whether the system prompts to connect an error, such as the system prompt error Check if the firewall is blocked the network access port of SQL Server or Java IDE If yes, turn off the firewall, restart SQL Server and Java IDE, test, if the system Still prompting the above mistakes, 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 Control Boundary Directory> SQL Server Group> Database 2) On the Corresponding "Database", select "Properties" 3) Select the General tab, click on "Network Configuration" If there is no "TCP / IP Protocol" in the protocol enabled 4) Select "TCP / IP Protocol", click "Properties", check if its port number is 14335), such as the port number is 1433 to modify it to other ports No., 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)
