Troubleshooting of exceptions during mssql2000 mounting and JDBC connection Suspension

Come to the company has been using the previous system, installed with mssql2000. But a few days ago, the system crashed, so I made a system. When mssql2000 is installed, the system prompts "previousProgramInstall a file that has been suspended on the installation computer. You must restart the computer before running the installer! The problem persists, So I went online and asked questions. I found a solution for others. I tried it and it was very helpful. Today, I spent my time giving my Buddha a hand and taking notes.

The method is to delete information in the registry. The specific method is to open the Registry (START-> Run-> regedit or Windows key + r ), find the pendingfilerenameoperations project in HKEY_LOCAL_MACHINE/system/CurrentControlSet/control/Session Manager and delete it. In this way, the temporary project is cleared, and then the installation is re-installed. OK, the installation is successful!

 

 

After the installation is successful, use JDBC to connect to mssql2000, and the result is a problem again. It's really strange. Why is it so difficult for Microsoft to do something, the program prompts "[Microsoft] [sqlserver 2000 driver for JDBC] Error establishing socket. at first, I thought it was a program problem, but I checked it carefully and found that the program was okay. So I went online and asked why I didn't install the SP4 patch.
To install the SP4 patch, follow these steps:
1. Download a SP4 patch package ,:
Http://www.microsoft.com/downloads/details.aspx? Familyid = 8e2dfc8d-c20e-4446-99a9-b7f0127f8bc5 & displaylang = ZH-CN
File Name: SQL2000-KB884525-SP4-x86-CHS.EXE
2. after installing the file "SQL2000-KB884525-SP4-x86-CHS.EXE", generate the "sql2ksp4" folder, which is equivalent to extracting the patch file, double-click "setup. BAT file to install the SP4 patch file.
Note: Install the MSSQL 2000 database before installing the SP4 patch file.

Restart the machine. Everything is OK!