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