Uninstalling SQL Server 2012

Source: Internet
Author: User
Tags visual studio 2008 professional mssqlserver management studio sql server management sql server management studio visual studio 2010

How to completely uninstall the SQL Server database
 
 I finally installed the sql server 2012 database, but I couldn't connect to the local database. Later I found that some services were missing, so I decided to reinstall, but the uninstallation was very troublesome. If the uninstallation was not clean, the reinstallation would cause problems, so the following Summarize some methods:
 
After uninstalling sql server 2012, everyone hopes to completely delete the registry information. The following will teach you how to completely delete the sql server 2012 registry for your reference. Before deleting, please be sure to make a backup.
Start after uninstalling SQL Server 2012-Run: Enter regedit to enter the registry editor, and perform the following operations after entering:
1. Completely delete SQL Server 2012:
hkey_local_machine \ software \ Microsoft \ MSSQLServer
hkey_local_machine \ software \ Microsoft \ Microsoft SQL Server
hkey_current_user \ software \ Microsoft \ Microsoft SQL Server
hkey_current_user \ software \ Microsoft \ MSSQLServer
hkey_local_machine \ system \ currentcontrolset \ control \ sessionmanager \ pendingfileren ameoperations
 
2. Relevant information deleted from the registry:
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer.
HKEY_LOCAL_MACHINE \ System \ CurrentControlSet \ Services \ MSDTC.
Find the PendingFileRenameOperations item in HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager and delete it. This will clear the installation pending items
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ setup
Remove ExceptionComponents
3. Run the registry and delete the following items:
HKEY_CURRENT_USER \ Software \ Microsoft \ Microsoft SQL Server
 
HKEY_USERS \ S-1-5-21-2668230077-3704407121-3760209252-500 \ Software \ Microsoft \ Microsoft SQL Server
 
HKEY_USERS \ .DEFAULT \ Software \ Microsoft \ VisualStudio
 
HKEY_USERS \ .DEFAULT \ Software \ Microsoft \ SQL Server Management Studio
 
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server
 
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer
 
4.Check which sqlserver services are left in the service list, and then delete all sqlserver related services in the following places.
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services
Delete the SQL SERVER installation path, such as: C drive-Microsoft SQL Server folder under Program File
Restart the computer
 
SQL Server 2012 is really annoying ~ It is not easy to uninstall ~ The following methods are provided for those "lazy" who are too lazy to reinstall the system ~ Pro test ~
1. Stop all related services of SQL Server 2012
2. In the control panel "Add and Remove Programs", delete the SQL SERVER2012 related programs
3. Download the Windows Install Clean Up tool to uninstall the SQL 2012 components (google it ~ about how to write too lazy, see if you know) delete all SQL services
4. Clear the registry
   Delete all Microsoft SQL Server folders under HKEY_CURRENT_USER --- Software ---- Microsoft
   HKEY_LOCAL_mACHINE --- SOFTWARE --- Microsoft SQL Native Client, Microsoft SQL Server, Microsoft SQL Server 2012Redist under Microsoft
5. Delete residual files
6. Delete the SQL SERVER installation path, such as: C drive-Microsoft SQL Server folder under Program File
7. Restart the computer (this world is clean)
 
Note: Execute the uninstall instance program provided by sqlserver2012. Although the instance is uninstalled, the instance is still visible in the service of the system. Then, first clean up the registry according to the above method, and then restart the computer.
 
 
Fix software installation issues and software uninstall issues
            Automatically diagnose problems on your computer that prevent installation and uninstallation of programs. Helps repair programs that don't uninstall properly and programs that prevent new programs from installing.
                    Issues fixed ...
Delete the wrong registry key on a 64-bit operating system.
Windows registry keys that control corrupted upgrade (patch) data.
Addresses an issue that prevents new programs from installing.
Addresses an issue that prevents programs from completely uninstalling and prevents new installations and updates.
Use this troubleshooter only if the program cannot be uninstalled using the Windows Add / Remove Programs feature.
                    Runs on
Microsoft Windows Server 2003
Microsoft Windows Server 2003 R2
Microsoft Windows XP
Windows 7
Windows Server 2008
Windows Server 2008 R2
Windows Vista
Windows 8
Windows 8.1
Windows Server 2012 editions
Windows Server 2012 R2
Suitable for ...
Microsoft Visual Studio 2005
Microsoft Visual Studio 2005 Professional Edition
Microsoft Visual Studio 2005 Professional Edition with MSDN Premium Subscription
Microsoft Visual Studio 2005 Professional Edition with MSDN Professional Subscription
Microsoft Visual Studio 2008
Microsoft Visual Studio 2008 Standard Edition
Microsoft Visual Studio 2008 Professional Edition
Microsoft Visual Studio 2008 Express Edition
Microsoft Visual Studio 2008 Academic Edition
Microsoft Visual Studio 2008 Software Development Kit
Microsoft Visual Studio 2008 Tools for Applications Software Development Kit
Microsoft Visual Studio 2008 Shell (integrated mode)
Microsoft Visual Studio 2008 Shell (isolated mode) Redistributable Package
Microsoft Visual Studio 2010
Microsoft Visual Studio 2010 Ultimate with MSDN
Microsoft Visual Studio 2010 Ultimate
Microsoft Visual Studio 2010 Professional with MSDN
Microsoft Visual Studio 2010 Professional
Microsoft Visual Studio 2010 Professional with MSDN Embedded
Microsoft Visual Studio 2010 Premium
Microsoft Visual Studio 2008 Professional Edition with MSDN Embedded
Microsoft Visual Studio 2010 Remote Debugger
Microsoft Visual Studio 2010 Shell (Isolated)
Microsoft Visual Studio 2010 Shell (Integrated)
Microsoft Visual Studio 2010 Software Development Kit


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.