How to completely uninstall sql2005?

"Statement" The following content for Baidu excerpt.

I think many of you have encountered SQL Server installation failure or error when you need to uninstall SQL Server, but SQL Server full uninstall is a very troublesome problem, often uninstall dirty, not which process did not kill, that is, which service did not uninstall, and no ready tools, uninstall incomplete , and reload the problem. What to do? Now, in my experience, let me introduce you to a method:

The first step, download the uninstall tool Msicuu2.exe file from the Microsoft website, you can download this tool from http://www.support.microsoft.com/default.aspx?kbid=290301, after downloading the installation

Click on the SQL Server 2005 related program and click the Remove button to uninstall.

Or, download SRVINSTW from the website, which is also a good tool to uninstall Windows services,


Uninstall the SQL Server service so that it is much cleaner.

In the second step, click "Run" in the "Start" menu and enter Regedit to enter the registration form:
Put HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
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
All deleted, but generally, if you use the Uninstall tool, it will not be available in the registry.


Third, to get the most insurance, make sure that the Start menu and the "Control Panel/Add removal program" Do not have SQL Server folders and files, and then delete the SQL Server files that are left in the C:\Program files\ or D:\Program Files folder. If you cannot delete it, please install the Unlocker tool and remove it.


Fourth step, restart the computer, install SQL SERVER 2005, should be OK.
But, if! If! If you encounter a COM + directory warning, find distributed Transaction Coordinator This service, start, if this does not start it may be distributed Transaction Coordinator This service relies on the MSDTC this server is disabled, starting the MSDTC service is OK.
Open the MSDTC service method:
Click start → run → enter command "msdtc-resetlog" to run the command.