Completely uninstall SQL Server 2008r2

"51" When the system reinstall, in the case of SQL Server 2008 is not uninstalled, try to install SQL Server 2008R2, the installation prompt was successful but prompted a few errors, found that SSMs was not found, as well as in the SQL Server Configuration Manager service also only poor one , an instant feel bad, no way can only re-uninstall the installation, in the online no thread found a few introduction of the unloading method of the document, seemingly uninstalled, but the installation of their own when there is a problem, there is ssms but the Configuration Manager service is only one, this situation ssms is not connected to the server, I just use my spare time to search for a few days, a little bit of the feeling of collapse, the Internet is circulating to uninstall SQL hard to reinstall the system ... But tonight after a comprehensive exploration of the various uninstallation methods, the perfect uninstall of SQL and the installation run SQL Server 2008r2 all aspects of the success of the function.

The uninstall software that is used to uninstall the SQL Server2008 R2 method is described below: Total Uninstall 6 and Windows Install clean up:

1) First uninstall the SQL SERVER2008R2 component in the "Add/Remove Programs" Control Panel of the system, first uninstall the "Microsoft SQL Server2008r2" component (follow the provided process), refresh the control panel after uninstallation, "Microsoft SQL Server2008r2 "There is still a temporary disregard, uninstall the other SQL Server 2008r2 components in turn;

2) Open the registry (start-run--regedit--OK) and then locate the following folder and delete it:
Hkey_current_user\ software\ microsoft\ Microsoft SQL Server,

hkey_local_machine\ software\ microsoft\ Microsoft SQL Server (this place note that there may be some components of your installation that are registered in this neighborhood, the name prefix is Microsoft SQL, deleted),

Hkey_local_machine\ software\ microsoft\ MSSQLServer,

Here's another one, but instead of deleting the folder, just delete one of the Pendingfilerenameoperat ions:
Hkey_local_machine\ SYSTEM\CurrentControlSet\Control\Session Manager\pendingfilerenameoperat ions

3) Open Run Total Uninstall 6 and uninstall after finding Microsoft SQL SERVER2008R2 analysis.

4) Open the run Windows Install clean up and locate the service for SQL Server 2008r2 (as long as you have the SQL Server 2008r2 option) and "REMOVE".

5) Locate the default installation path C:\Program Files\Microsoft SQL folder and remove it with administrator privileges, the "Microsoft SQL Server2008r2" in the control Panel is also missing, so restarting the computer completes the SQL SERVER2008R2 's perfect uninstall.

The above is personal experience, there is a mistake to welcome guidance.

Category: MSSQL

Completely uninstall SQL Server 2008r2