SQL2000 solution that cannot be installed after uninstalling the reinstall

1, the Program files under the SQL installation directory Delete (here if there are important data, please back up)

C:Program FilesMicrosoft SQL Server80tools.

C:Program FilesMicrosoft SQL Servermssql.

2, the relevant information in the registry delete:

Hkey_local_machinesoftwaremicrosoftmssqlserver.

Hkey_local_machinesystemcurrentcontrolsetservicesmsdtc.

3. Find the PendingFileRenameOperations project in Hkey_local_machinesystemcurrentcontrolsetcontrolsession Manager and delete it. This allows you to clear the installation pending items.

4, Hkey_local_machinesoftwaremicrosoftwindowscurrentversionsetup
Delete Exceptioncomponents

There may be a lot of content under this project, use this method only if the above methods do not work (note that do not delete all)

Read the contents before deleting the content

5, the Sqlstp.log file in the Windows directory that lists the details of what the installer is doing and includes any errors encountered during installation. By examining the file, you can learn more about where the installation failed and why it failed.

6. The error message for SQL installation is stored in a log file called Errorlog, which is located in the program FilesMicrosoft SQL servermssqllog directory by default. The error log contains errors that Sql-server encountered when the installer attempted to start Sql-server, which can help you drill down into the cause of the error.

7. Another component that needs to be checked is the Microsoft Data Access Component (MDAC) installer, which is started as part of the sql-server2000 Setup program. 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 does not cause problems.

Problem two: Prompt when installing: Unable to read the specified file, most likely due to improper network connection, please correct the problem and restart setup. File: Q:personalx86setup. Binn Es1033sqlmmc.rll

Solution: There is a problem with the installer itself, it is recommended to change the installation program.

Question three: installation prompts to find the SQL installation log, directory in C:WINDOWSSQLSTP, Open will see a general network error log, as follows

-------------------------------------------
Driver={sql Server};server=soyo; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC SQL Server Driver] [Shared Memory] General network error.

[Microsoft] [ODBC SQL Server Driver] [Shared Memory] Connectionread (Wrapperread ()).

Driver={sql Server};server=soyo; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC SQL Server Driver] [Shared Memory] General network error.

[Microsoft] [ODBC SQL Server Driver] [Shared Memory] Connectionread (Wrapperread ()).

Driver={sql Server};server=soyo; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC SQL Server Driver] [Shared Memory] General network error.

[Microsoft] [ODBC SQL Server Driver] [Shared Memory] Connectionr

-----------------------------------------------