"51" When the system reinstall, without uninstalling SQL Server 2008, try to install SQL Server 2008R2, the installation prompts a successful but prompted a few errors, found no ssms, and in the SQL Server Configuration Manager services are only a poor one , and instantly feel bad, there is no way to uninstall the installation, on the Internet to find a few to introduce the uninstall method of the document, seemingly unloaded, but the installation of their own when there are problems, there are 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 blindly toss a few days, a little near the feeling of collapse, the Internet is in circulation Uninstall SQL difficult to reload the system ... But tonight after a comprehensive exploration of each uninstall method after the perfect uninstall SQL and installation Run SQL Server 2008r2 all aspects of the successful function.
The following is an overview of uninstalling the SQL Server2008 R2 method, using the Uninstall software: Total Uninstall 6 and Windows Install clean up:
1 First uninstall the SQL SERVER2008R2 component in the system's Control Panel "Add/Remove Programs", uninstall the "Microsoft SQL Server2008r2" component (follow the provided process), refresh Control Panel after uninstalling, "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 is the place to note that, in the vicinity, there may be some of your installed components registered, 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 the Pendingfilerenameoperat ions one:
Hkey_local_machine\ SYSTEM\CurrentControlSet\Control\Session Manager\pendingfilerenameoperat ions
3 Open Run Total Uninstall 6 and locate the Microsoft SQL SERVER2008R2 analysis and uninstall it.
4 Turn on the run Windows Install clean up, locate the services for SQL Server 2008R2 (as long as you have SQL Server 2008r2 Word), 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 Control Panel is also missing, so restarting the computer completes the SQL SERVER2008R2 the perfect uninstall.
The above is personal experience, there is the wrong place to welcome advice.
After testing, even if the file is deleted, if the server has used a secure dog to do SQL Server 2008 security, be sure to restore the settings first, then uninstall, or you will not be able to install.