Daktronics

How to remove/uninstall SQL Server 2005, 2008 or 2014.

Topic

  • Remove SQL Server 2005
  • Remove SQL Server 2008
  • Remove SQL Server 2014

Environment

  • Product:
  • Component: SQL2005, SQL2008, SQL2014
  • Control System: Venus 1500 V4, Display Studio (Show Control, SCS)

Steps

Registry disclaimer
This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it (Step 5 below). Then, you can restore the registry if a problem occurs.

Note: If there are other programs that are using SQL for a database, this option is not available as it removes all the database information and files.

Follow: How To Remove/Uninstall the Nucleus Database when there are multiple database instances.

SQL 2005\SQL 2008

To uninstall SQL Server 2008/2005, complete the following steps:
  1. Make sure you have administrative rights on the computer.
  2. Back up customers database following: Venus 1500: How to uninstall version 4 or Venus 1500: How do I use the Nucleus Server Database utility to transfer or save a database?
  3. Uninstall the existing Microsoft SQL Server 2005 or 2008 and all the components from Program and Features. After uninstalling 1st component (from picture below) refresh programs and features page and uninstall any Microsoft SQL components left listed. The Daktronics database will be named "NUCLEUS"
    SQL08Uninstall.png
  4. Rename or remove all the SQL Server folders on the computer.
    • C:\ProgramFiles (x86)\Microsoft SQL Server
  5. Download CCleaner and run the Registry Cleaner utility by clicking the Registry button on the left.
    • Backup the registry when prompted by CCleaner. (If not running CCleaner before doing anything in registry follow: How to save registry backup.)
    • NOTE: When running the CCleaner setup file be sure to disable the installation of any added product. These are generally Google Chrome or AVG.
  6. Delete the following keys in regedit:
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server.
    • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server
    • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer
    • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server. 
  7. Run CCleaner (may need to run scan multiple times to ensure it shows no more issues).
  8. Reboot the machine.

SQL 2014
Note: If there are other programs that are using SQL for a database, this option is not available as it removes all the database information and files.

Follow: How To Remove/Uninstall the Nucleus Database when there are multiple database instances.

To uninstall SQL Server 2014, complete the following steps:
  1. Make sure you have administrative rights on the computer.
  2. Back up customers database following: Venus 1500: How to uninstall version 4 or Venus 1500: How do I use the Nucleus Server Database utility to transfer or save a database?
  3. Uninstall the existing Microsoft SQL Server 2014 and all the components from Programs and Features. After uninstalling 1st component (from picture below). The Daktronics database will be named "NUCLEUS"
    • Be sure to select both -
      • Database Engine Services
      • SQL Client  Connectivity SDK
    • Refresh programs and features page and uninstall any left over Microsoft SQL components
      • Note: Examples - Microsoft ODBC Driver 11 for SQL Server, 2008 Setup Support Files, and 2012 Native Client are the common left overs but could be anything Microsoft SQL related
        SQL2014Uninstall.png
  4. Rename or remove all the SQL Server folders in the computer.
    • C:\Program Files (x86)\Microsoft SQL Server
  5. Download CCleaner and run the Registry Cleaner utility by clicking the Registry button on the left.
    • Backup the registry when prompted by CCleaner. (If not running CCleaner before doing anything in registry follow: How to save registry backup.)
    • NOTE: When running the CCleaner setup file be sure to disable the installation of any added product. These are generally Google Chrome or AVG.
    • After the scan is complete run the fix all found issues. (May need to run the scan multiple times to ensure it shows no more issue).
  6. Delete the following keys in regedit:
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server.
    • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server
    • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer
    • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
  7. Run CCleaner (may need to run scan multiple times to ensure it shows no more issues).
  8. Reboot the machine.

KB ID: DD3522855

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.