How to uninstall the SQL Server database completely

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

How to completely uninstall the SQL Server database is not easy to install the SQL Server 2012 database, but can not connect to the local database, and later found that the lack of some services, then decided to reinstall, but the uninstall is very troublesome, if the uninstall is not clean, reinstall will be problematic, So here are some ways to summarize: After uninstalling SQL Server 2012, you want to be able to completely delete the registry information, the following will teach you to completely remove the SQL Server 2012 registry method, for your reference, before deleting, please be sure to do a good job of backup yo. Start with uninstalling SQL Server 2012-run: Enter Regedit to enter the Registry Editor, and then do the following: 1. Completely remove SQL Server 2012:hkey_local_machine\software\microsoft\ Mssqlserverhkey_local_machine\software\microsoft\microsoft SQL serverhkey_current_user\software\microsoft\ Microsoft SQL serverhkey_current_user\software\microsoft\mssqlserverhkey_local_machine\system\currentcontrolset\ Control\sessionmanager\pendingfileren ameoperations 2. Related information in the registry is removed:HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC. Locate the PendingFileRenameOperations project in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager and delete it. This allows you to clear the Install pending item HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup Delete exceptioncomponents 3, run the registry, Delete the following: 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 StudioHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL ServerHKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer 4, see what SQL Server services are remaining in the list of services, and then delete all SQL Server related services in the following places.  hkey_local_machine\system\ currentcontrolset\services  the SQL Server installation path, such as: C-Drive--program file under Microsoft SQL server folder Delete   Restart the computer    sql server 2012 really annoying ~ not easy to unload clean ~ The following methods are provided to those who do not bother to reload the system of "lazy people" ~ Pro-Test ~ 1. Stop all SQL SERVER 2012 related services  2. In the Control Panel Add Remove Programs, delete the SQL SERVER2012 related programs  3. Download the Windows Install Clean up tool to uninstall SQL 2012 components (Google it ~ about how to use lazy writing, I'll see. Delete all SQL Services 4. Clear the registry      Remove all HKEY_CURRENT_USER---Software Microsoft SQL server folders under Microsoft----      HKEY_LOCAL_MACHINE---Software---Microsoft SQL Native Client under Microsoft, Microsoft SQL Server, Microsoft SQL Server 2012Redist Remove all 5. Delete the remaining files  6. Remove the Microsoft SQL Server folder under the SQL Server installation path, such as: C-Drive--program file  7. Restart the computer (the world is Clean)    Note: The execution of the sqlserver2012 provided by the uninstall instance program, although the instance is uninstalled, but in the system's services can be seen in this instance. So, first clean up the registry as above, Then restart your computer to    fix software installation issues and software uninstallation issues                  Automatic DiagnosticsProblems with installing and uninstalling programs are blocked on your computer. Help repair programs that are not properly uninstalled and programs that prevent new programs from installing.                              Fix the problem ...                 
    • Delete the wrong registry key on the 64-bit operating system.
    • A Windows registry key that controls corrupted upgrade (patching) data.
    • Resolves an issue that prevents the installation of new programs.
    • Resolves an issue that prevents a program from uninstalling completely and blocking new installations and updates.
    • Use this troubleshooter to uninstall only if the program cannot be uninstalled by using the Windows Add/Remove Programs feature.
Run on ...
    • Microsoft Windows Server 2003
    • Microsoft Windows Server 2003 R2
    • Microsoft Windows XP
    • Windows 7
    • Windows Server 2008
    • Windows Server R2
    • Windows Vista
    • Windows 8
    • Windows 8.1
    • Windows Server Editions
    • Windows Server R2
Apply to ...
  • 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 Standard Edition
  • Microsoft Visual Studio Professional Edition
  • Microsoft Visual Studio Express Edition
  • Microsoft Visual Studio Academic Edition
  • Microsoft Visual Studio Software development Kit
  • Microsoft Visual Studio Tools for Applications software development Kit
  • Microsoft Visual Studio-Shell (Integrated mode)
  • Microsoft Visual Studio Isolated Mode redistributable Package
  • Microsoft Visual Studio 2010
  • Microsoft Visual Studio Ultimate with MSDN
  • Microsoft Visual Studio Ultimate
  • Microsoft Visual Studio Professional with MSDN
  • Microsoft Visual Studio Professional
  • Microsoft Visual Studio Professional with MSDN Embedded
  • Microsoft Visual Studio Premium
  • Microsoft Visual Studio Professional Edition with MSDN Embedded
  • Microsoft Visual Studio Remote Debugger
  • Microsoft Visual Studio-Shell (Isolated)
  • Microsoft Visual Studio-Shell (Integrated)
  • Microsoft Visual Studio Software development Kit

How to uninstall the SQL Server database completely

Related Article

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.