Annoying SQL2005, in the server installed, but also deliberately played a SP2 patch, incredibly only on the server can connect, outside the net incredibly connected. Tried many many ways, the configuration many many times, or the big one, simply unload.
My friend recommended me to install SQL2008, a hard-hearted, also can not control the SQL2008 of the oversized volume, but the installation is wrong, incredibly prompted to uninstall: SQL2005. Obviously unloaded, did not unload clean? This SQL2005 is really smell enough. summed up the complete uninstall SQL2005 method, and share with you!
The relevant software download address: http://www.jb51.net/softs/82961.html
1.Stop All Services
2. Uninstall SQL2005 components with Windows Install clean up tool
3. Remove all SQL services with SrvInstw.exe
4. Clean up the registry
A. Remove HKEY_CURRENT_USER---Software----Microsoft SQL Server folder under Microsoft
B. HKEY_LOCAL_MACHINE---SOFTWARE---Microsoft SQL nativeclient Microsoft SQL Server, Microsoft SQL Server 2005Redist Delete all.
or clear the registry
Hkey_local_machinesoftwaremicrosoftmicrosoft SQL Server
Hkey_local_machinesoftwaremicrosoftmssqlserver
Hkey_local_machinesoftwaremicrosoftmicrosoft SQL Native Client
Hkey_local_machinesoftwaremicrosoftmicrosoft SQL Server Redist
Hkey_local_machinesystemcurrentcontrolsetservicesmssqlserver
Hkey_local_machinesystemcurrentcontrolsetservicessqlserveragent
Hkey_local_machinesystemcurrentcontrolsetservicesmssqlserveradhelper
Hkey_current_usersoftwaremicrosoftmicrosoft SQL Server
If deleting the above registry does not work, delete the following registry information:
Uninstall the Microsoft Search Service and also need to remove: hkey_local_machinesoftwaremicrosoftsearch
Uninstall the Microsoft Full-text Query and also remove:
Hkey_local_machinesystemcurrentcontrolsetservicesmsftpsvc
Hkey_local_machinesystemcurrentcontrolsetservicesmsscntrs
Hkey_local_machinesystemcurrentcontrolsetservicesmssearch
Hkey_local_machinesystemcurrentcontrolsetservicesmssgatherer
Hkey_local_machinesystemcurrentcontrolsetservicesmssgthrsvc
Hkey_local_machinesystemcurrentcontrolsetservicesmssindex
5. Delete residue files
Delete the Microsoft SQL Server folder under--program file, C. If you are in a different disk (such as D), you should delete all the SQL files related to the other disk (d disk). If you cannot delete it, install the Unlocker tool and remove it.
Search for SQL under Windows C disk. Delete all files found (search for SQL under hidden file inf, delete all files found). (Test not to do)
To the Control Panel--management tools--Computer Management--Local Users and groups--group, delete all SQL related information. (Test not to do)
6. Reboot the computer and reinstall it.
But if! If you encounter a COM + catalog warning, find the distributed Transaction Coordinator this service, start, if this does not start can be distributed Transaction Coordinator This service is dependent on MSDTC This server is disabled, starting the MSDTC service is OK.
Open the MSDTC service method:
Point start → run → enter Command "Msdtc-resetlog", run the command.