Process for Removing an Instance

Before you begin

Note:
If you use full SQL 2005, 2008 or 2012 you must have full SQL available to recreate the instance.

Procedure

  1. Uninstall the existing SQL Instance from within windows, select Start > Control Panel > Programs & Features (or Add/Remove Programs).
    • Highlight Microsoft SQL 2005, 2008, or 2012(3.15+) click Remove or Uninstall
    • Select Instance HCNSQL07, click Next
    • Click the Finish button when presented with the completion window
    • Repeat 1.1 – 1.3 for the ESP instance.
  2. Rename the following folders, by adding a suffix consisting of the current date. For example, the 'MSSQL10_50.HCNSQL07' folder becomes 'MSSQL10_50.HCNSQL07' 25-03-11'.

    For 32 Bit Operating Systems:

    • SQL 2005: C:\Program Files\Microsoft SQL Server\MSSQL.*
    • SQL 2008: C:\Program Files\Microsoft SQL Server\MSSQL10.HCNSQL07
    • SQL 2008 R2: C:\Program Files\Microsoft SQL Server\MSSQL10_50.HCNSQL07
    • SQL 2012: C:\Program Files\Microsoft SQL Server\MSSQL11.HCNSQL07

      For 64 Bit Operating Systems with 32bit SQL (3.12+):

    • SQL 2005: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.*
    • SQL 2008: C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.HCNSQL07
    • SQL 2008 R2: C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.HCNSQL07
    • SQL 2012: C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.HCNSQL07

      For 64 Bit Operating Systems with 64bit SQL (3.12+):

    • SQL 2008: C:\Program Files\Microsoft SQL Server\MSSQL10.HCNSQL07
    • SQL 2008 R2: C:\Program Files\Microsoft SQL Server\MSSQL10_50.HCNSQL07
    • SQL 2012: C:\Program Files\Microsoft SQL Server\MSSQL11.HCNSQL07
      Note:
      If errors were encountered during the removal of the instance you will need to browse the registry and complete the following:

      For 32 Bit Operating Systems (removing only the instance name)

    • HKey_Local_Machine > Software\Microsoft\Microsoft SQL Server
    • HKey_Local_Machine > Software\Microsoft \Microsoft SQL Server
    • HKEY_Local_Machine > System > ControlSet001 > Services

      For 64 Bit Operating Systems (3.12+)

      Check the 32-bit system registry locations listed above, and then the following:

    • HKey_Local_Machine > Software\WOW6432node\ Microsoft > Microsoft SQL Server
    • HKey_Local_Machine > Software\WOW6432node\Microsoft\Microsoft SQL Server
    • HKey_Local_Machine > System\ControlSet001\Services
  3. Reboot the Server.
  4. If you use full SQL, you must recreate the HCNSQL07 and ESP instances. See Configuring a Full Microsft SQL Server .
  5. Return to Full 'Cleanout' Process for a Server Step 6.

Results