Manually uninstall the SQL Server 2000 database

The same problem was found in the installation of the application system for all the cooperative schools, when the SQL Server 2000 database in the school was damaged, and the installation of the SQL Server database was unsuccessful. Reason: Even if you uninstall the SQL Server database normally through the Add/Remove program in the Control Panel, SQL Server is not completely uninstalled, and you need to do something manually. So the reinstall is not successful, many people have to reinstall the system to solve. After a long period of exploration and practice summary, I found a little technical method, here to share with you.

Operation Steps:

It is recommended that you back up the registry and the important database files before doing so.

First, we try to use the IsUninst.exe uninstall program to safely uninstall programs and their associated components in Windows:

(1) Run Regedit.exe, and then locate the following registry key:

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall

(2) Under Uninstall, locate the product code for the Microsoft SQL Server2000 instance that you want to delete.

(3) on the taskbar, click the Start button, and then click the Run button. In the Run dialog box, copy and paste the following commands, such as:

C:\WINNT\IsUninst.exe-f “C:\Program Files\Microsoft SQL Server\MSSQL＄Server1\Uninst.is”
-c”C:\Program Files\Microsoft SQL Server\MSSQL＄Server1\sqlsun.dll”-Mssql.miff I=Il

Where: MSSQL Serverl indicates that the instance named Serverl is installed.

If the above method does not work, then we have to manually delete the operation.

(1) Delete the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVER AGENT
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services \MSSQLServerADHelper

(2) Manually delete the installation directory, which is located by default:

C:\Program Files\Microsoft SQL Server

(3) Uninstall the Microsoft Search Service and also remove:

Hkey_local_machine\software\microsoft\search

(4) Uninstall Microsoft Full-text Query and also delete:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSFTPSVC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSCNTRS
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSGATHERVER
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSGTHRSVC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSINDEX

(5) If you want to uninstall a named instance, add "/" and the corresponding instance name after the corresponding registry key mssqlserver,sqlserveragent and MSSQLServerADHelper.

Here we have successfully uninstalled the SQL Server database completely.