Solution to installation failure after sql2000 is uninstalled and re-installed

1. Delete the SQL installation directory under Program files (back up important data first)
C: Program FilesMicrosoft SQL Server80Tools.
C: Program FilesMicrosoft SQL ServerMSSQL.
2. Delete related information in the registry:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer.
HKEY_LOCAL_MACHINESystemCurrentControlSetServicesMSDTC.
3. Find the PendingFileRenameOperations project in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager and delete it. In this way, you can clear the temporary installation project.
4. HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionsetup
Delete predictioncomponents
There may be a lot of content in this project, and this method can be used only when the above methods are not feasible (Be sure not to delete all)
Before deleting the content, read the description.
5. The Sqlstp. log file in the Windows directory lists detailed information about the operations performed by the installer and contains all errors encountered during installation. By checking this file, you can learn in detail where the installation fails and why it fails.
6. The error message during SQL installation is stored in a log file named Errorlog. By default, this file is stored in the Program FilesMicrosoft SQL ServerMssqlLog directory. This error log contains the errors encountered by SQL-Server when the installer tries to start SQL-Server. This information can help you thoroughly check the cause of the error.
7. Another component to be checked is the Microsoft Data Access Component (MDAC) Installer which starts as part of the SQL-Server2000 installer. The SQL-Server2000 installer installs MDAC2.6. The MDAC installer creates a separate log file named Dasetup. log. You can view this log file and ensure that the MDAC installer has no problems.
Problem 2: During installation, the system prompts that the specified file cannot be read, which is probably caused by abnormal network connection. correct the problem and restart the installer. File: Q: personalx86setup .. binn es1033sqlmmc. rll
Solution: if there is a problem with the installer, we recommend that you change the installer.
Question 3: the installation prompt is to find the SQL Installation Log, which is in the C: windowssqlstp directory. The general network error log is displayed when it is opened, as shown below:
-------------------------------------------
Driver = {SQL server}; server = soyo; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionRead (WrapperRead ()).
Driver = {SQL server}; server = soyo; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionRead (WrapperRead ()).
Driver = {SQL server}; server = soyo; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionR