How to uninstall the Sophos Control Center

  • Artikel-ID: 11019
  • Aktualisiert: 03 Nov 2014

This article explains how to uninstall the Sophos Control Center as previously used by Small Business customers.  All instructions in this article should be completed on the computer with Sophos Control Center installed.

Sophos Control Center was retired in June 2014 and hence no longer supported.  You should either upgrade to Enterprise Console or follow the instructions below to uninstall the software.

Important: This article is not designed to troubleshoot problematic uninstalls.

Applies to the following Sophos product(s) and version(s)

Sophos Control Center

What To Do

Note:

  • To uninstall the associated Window endpoint software see article 12360, and for instructions for Mac computer see article 119182.
  • In the instructions below the symbol ↵ represents one press the enter (return) key on the keyboard.
  • Before attempting the instructions below ensure the Control Center is closed.  Example:

1. Uninstall the Control Center

  1. Open 'Programs and Features' via the Control Panel (which is named 'Add/Remove Programs' for earlier Windows operating systems).  Alternatively open the same window directly by press Windows + R on your keyboard, and typing appwiz.cpl into the run box and pressing enter.

  2. From the list locate and select the 'Sophos Control Center' component.  The 'InstallShield Wizard' will run.

  3. Click 'Next'.

  4. From the 'Program Maintenance' screen select 'Remove' and click 'Next'.



  5. To start the uninstall, click 'Remove'.  Wait while the uninstaller checks the installed components.  The uninstall may take several minutes to complete.

  6. When completed click 'Finish' to close the uninstaller.

The Control Center software is now uninstalled, but you should continue with section two below to remove the unused Sophos Control Center database.

2. Remove the Sophos database

By default the Control Center uses a SQL Server instance called 'Sophos'.  In order to correctly remove as much of the database component, you must determine if any other software (such as Sophos PureMessage for Microsoft Exchange) is sharing the same SQL Server instance.

If the SQL Server instance is only used by the Control Center you can remove the entire SQL Server instance.  If the instance is shared by another program (like PureMessage) you should only 'drop' (delete) from the SQL Server instance the databases used by the Control Center.

Confirm if the SQL Server instance is shared between applications

  1. Open a command prompt (Start | Run | Type: cmd.exe | Press enter).
  2. Type the following case-sensitive commands followed by enter (where ↵ is shown):

    sqlcmd -E -S .\sophos
    select name from sysdatabases
    go

    A list of database names is displayed in on screen.  Example:



    The example above shows an installation of the Control Center database where it is hosted inside a SQL Server instance shared by PureMessage.  The example highlights: the red arrows are pointing at general databases that are used by the SQL Server to manage and maintain the instance, are not Sophos databases, and are only required while there is one or more applications making use of the instance.  The yellow arrows are pointing to the actual Control Center databases we are interested in removing.  The green arrows are Sophos PureMessage for Microsoft Exchange databases.

You can ignore the 'master', 'tempdb', 'model', and 'msdb' databases (as these are not databases used by external programs).  However if you see database names mentioning 'Savex...' you have PureMessage databases hosted in the instance.  These databases may be left over after the removal of PureMessage (as designed to prevent data loss).  However if you are still using PureMessage and decide to uninstall the entire SQL Server instance (option [B] below) you will break PureMessage.  If you need to keep the SQL Server instance - because of other databases hosted by it - you should follow option [A] below to just drop (i.e., de-attach from the SQL Server instance) the databases associated with the Control Center.

[A] Drop the Control Center databases from the SQL Server instance

Note:  Even though you are uninstalling the Control Center we recommend you take a backup of the latest Sophos database in case you need to restore it later on, or access the data held in it.

  1. Open a command prompt (Start | Run | Type: cmd.exe | Press enter).
  2. Type the following case-sensitive commands followed by enter (where ↵ is shown):

    sqlcmd -E -S .\sophos
    select name from sysdatabases
    go

    A list of database names is displayed in on screen.  Note the names of any databases with the name 'Sophos..' followed by a number.  If you have, for example, a 'SOPHOS4' and a 'SOPHOS2' database you need to 'drop' two databases.

  3. To drop the SOPHOS4 database type:

    drop database sophos4

    Repeat for the SOPHOS2 database if necessary - changing the '4' in the command above to '2'.

  4. Run the commands from step two above and confirm the 'SOPHOS4' (and maybe 'SOPHOS2') databases are no longer listed.

  5. Locate the physical files in the SQL Server folder.  Typically the folder folder will be:

    C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\

    Note: For 64-bit servers change 'Program Files' for 'Program Files (x86)'.

  6. In the Data folder delete the 'SOPHOS4.mdf' and 'SOPHOS4_log.ldf' files.  If you also dropped the SOPHOS2 database in step three above you should delete the 'SOPHOS2.mdf' and 'SOPHOS2_log.ldf' files too.

[B] Uninstall the entire SQL Server Sophos instance

Note:

  • Removing the entire Sophos SQL Server instance while other applications are using it will break those applications.  Ensure that you have read and understood the section Confirm if the SQL Server instance is shared between applications above before proceeding.
  • The instructions shown below are specifically for Microsoft SQL Server 2005, however later SQL Server versions will be similar.

 

  1. Open 'Programs and Features' via the Control Panel (which is named 'Add/Remove Programs' for earlier Windows operating systems).  Alternatively open the same window directly by press Windows + R on your keyboard, and typing appwiz.cpl into the run box and pressing enter.
  2. Locate and select the 'Microsoft SQL Server 2005' component then click 'Change'.
  3. Select the 'SOPHOS: Database Engine' option and click 'Next'.  Example of the option:



  4. Select 'Database Engine' and click 'Next'.  Example of the option:



  5. The 'installation wizard' will run.  Click 'Next'.

  6. After the 'Configuration Check' is complete, click 'Next'.

  7. From the 'Change or Remove Instance' screen select 'Remove Microsoft SQL Server'.  Example:



  8. Click 'Next' on the 'Error and Usage Report Settings' screen.

  9. Click 'Remove' to fully uninstall this SQL Server instance.

  10. After the uninstall has run click 'Next' and finally 'Finish'.

Microsoft SQL Server is now uninstalled.

 
Wenn Sie weitere Informationen oder Unterstützung benötigen, wenden Sie sich bitte an den technischen Support.

Artikel bewerten

Ungenügend Hervorragend

Anmerkungen