jdbc connection to sql server database steps and one operation has been suspended, the computer needs to be restarted to solve the problem
Author：Eve Cole
Update Time：2009-07-03 17:03:39
When you first learn to use jdbc to connect to a database, you need to perform tedious configuration. It took me a day to finally figure out the correct configuration method! Here is a summary. The first step: download the JDBC driver package of SQL Server, install it in the Microsoft SQL Server 2005 JDBC Driver folder under program files on the c drive, and then configure
classpath, add C:Program FilesMicrosoft SQL Server 2005 JDBC Driversqljdbc_1.1chs on the original basis to indicate the directory where sqljdbc.jar is located.
Step 2: Download the sp4 patch of SQL Server and unpack it to a certain directory, then run setup.bat and install the wizard. During this process, I encountered the prompt "An operation has been suspended and the computer needs to be restarted." The way to solve this problem is to open the registry editor and find the PendingFileRenameOperations file in the HEY_LOCAL_MACHINESYSTEMCurrentContralSetContralSession Manager directory and clear this file.
Step 3: Check whether the default port of SQL Server is 1433. Method: Open the "Client Network Utility" "General" tab and there is an Enable Protocol box, select TCPIP to view its properties.
