SQL server2008 Full Uninstall

Source: Internet
Author: User
Tags microsoft sql server

The standard uninstall method does not completely clear the sqlserver2008, causing the reload SQL Server error, the following describes the full uninstall of sqlserver2008 database software without any software.

(1) Click "Start" in the lower right corner of the computer, click "Control Panel" and click "Program". In the list of programs, locate Microsoft SQL Server 2008, and right-click Uninstall (or double-click).

(2) Pop-up SQL Server uninstall prompt, click "Delete"

(3) The next standard uninstall for sqlserver2008

(4) If this error occurs, restart the computer to uninstall again

(5) Uninstall with 2008 related build, Start-Control Panel-Uninstall program, right click Uninstall. All related components are uninstalled.

(6) Delete the installation files on the disk (the general database is installed by default on the C drive) path "C:\Program files" to delete the "Microsoft SQL Server" folder, if the 64-bit system needs to remove "C:\Program Files (x86)" in the " Microsoft SQL Server "

(7) The "Start +r" on the keyboard can be run quickly, enter "regedit" and enter the Registry Editor.

Find: "SYSTEM" under "HKEY_LOCAL_MACHINE"--"CurrentControlSet"--"Control"--"session Manage" (Note, do not click "+" in front of the session manager) The number, not the "+" thing, is inside the session manager. Find the PendingFileRenameOperations value and delete it.

(8) The 6th step: Run the registry and delete the following:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer

(9) A 1406 error may occur due to a reload because the installer does not have permission to write a specific registry key value, you need to set permissions

9.1. Run the input box we fill in "regedit" and click the OK button.

9.2. Click the OK button to enter the Registry editing window.

9.3. After entering the Registry editing window, we then find and click Open HKEY_LOCAL_MACHINE folder, then locate and open \software\classes\msolapadmin2.msolapsources.1.

9.4. After locating the Msolapadmin2.msolapsources.1 registry key, select it and right-click to find the "permissions" option in the pop-up list.

9.5. After we find the right option, then we click to open it, in the open window, select "CREATOR OWNER" user, in the bottom of "Full Control" after the box to play √, and finally press OK to exit.

(10) Restart the system, SQL Uninstall clean, you can reinstall SQL Server.

SQL server2008 Full Uninstall

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.