Completely uninstall SQL 2005 Graphics tutorial

Source: Internet
Author: User
Tags microsoft sql server

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.