You have attempted to upgrade from Enterprise Console 5.0 to Enterprise Console 5.1 where all components are installed on the same computer.
The initial upgrade attempt failed leaving the computer with the following components installed as listed in 'Add or Remove Programs' or 'Programs and Features'::
- Sophos Management Database (5.1)
- Sophos Management Server (5.0)
- Sophos Management Console (5.0)
First seen in
Enterprise Console 5.1.0
The upgrade from Enterprise Console 5.0 to Enterprise Console 5.1 failed after performing the install of the 'Sophos Management Database' (5.1) component.
Potential causes for this failure can be found via article: 114627.
What To Do
- Uninstall the Sophos Management Database (5.1) entry from 'Add or Remove Programs' or 'Programs and Features'.
Note: This leaves the databases intact and attached to SQL Server.
- Run the Enterprise Console 5.1 installer, to perform an upgrade of the remaining components: 'Sophos Management Server' and 'Sophos Management Console'.
Important: It is assumed that the original cause for the failed upgrade is understood and corrected. See article 114627 for potential causes and solutions.
Tip: This can be found in the location:
- Once the upgrade is complete, Enterprise Console 5.1 should be fully operational. It is recommended that you launch Enterprise Console 5.1 to confirm this.
In order to complete the installation and to ensure that future upgrades are successful, version 5.1 of the database component should be re-installed. Doing so will DROP (delete) your SOPHOS51 database. For that reason, the databases will need to be backed up first. To do so, perform the following steps:
- Stop the following services:
Take a backup of the SOPHOS51, SOPHOSPATCH51 and SOPHOSENC51 databases.
- Sophos Message Router
- Sophos Management Service
- Sophos Patch Server Communicator
- Sophos Encryption Business Logic Service (only installed with Encryption)
To do so run:
C:\Program Files\Sophos\Enterprise Console\DataBackupRestore.exe -action=backup -subsystem=All -datasourcetype=Database
You should see a 'Succeeded' message after each database is backed up and a final 'Build Succeeded.' message.
Note: For more information on DatabackupRestore such as where the databases are backed up to, see article: 114299.
Important: The following steps will drop (delete) your SOPHOS51 database, it is important that you confirm the databases were backed up successfully during this step before continuing. If you have any doubt, please consult with Sophos support before continuing.
Should there be a problem with restoring the SOPHOS51 database following the database being dropped, as you have performed an upgrade from Enterprise Console 5.0 to Enterprise Console 5.1 and previous databases are not dropped (deleted), it would always be possible to populate the empty SOPHOS51 database with the data from SOPHOS50 by running UpgradeDB.exe as mentioned in article: 65420. The deltas should be minimal depending on the time elapsed since Enterprise Console 5.1 was installed.
Run the Enterprise Console 5.1 installer from:
Complete a 'modify' workflow by adding the 'Database' component when requested.
With the above services stopped, the installer will be able to drop (delete) and create a new database.
Once the installer has completed un-tick 'Start Sophos Enterprise Console' and close the installer by clicking 'Finish'. If you are given the option to log off or restart, un-tick the option and click 'Finish'.
Restore the previously backed up databases by running the command:
C:\Program Files\Sophos\Enterprise Console\DataBackupRestore.exe -action=restore -subsystem=All -datasourcetype=Database Launch Enterprise Console to ensure previous data is available. If you were asked to log off or restart at the end of the modify, first perform the log off or restart, before launching Enterprise Console.