This article describes how to install/upgrade the Sophos Management Database component on a different (remote) computer to that of the computer where the Sophos Management Server components are installed. The process described in this article applies to upgrading your distributed installation as well as fresh installs. The following sections are covered:
Applies to the following Sophos products and versions Enterprise Console 5.5.0Enterprise Console 5.5.1Enterprise ConsoleEnterprise Console 5.5.2
If you want to install/upgrade your Sophos Management Database component on a remote computer you must install/upgrade the database component first, before installing/upgrading other management components.
Before proceeding with the instructions below you should familiarize yourself with the different console versions and the associated database names. For further information see article 17323.
There are several methods for installing/upgrading the Sophos database on a different computer to the management server.
Once the Sophos Management Database component has been installed/upgraded:
Installing or upgrading the database component only creates the new databases as used by the version of the installation being installed/upgraded to. In addition to creating the new databases it ensures the 'database' account is a member of the Windows security group 'Sophos DB Admins' in order that the 'database' account has access to the databases.
On upgrades, the data is moved from the previous database to the new database as part of the management server install/upgrade process. The management server installer calls UpgradeDB.exe as part of the upgrade to initiate a move of the data from the previous to new databases. Note: UpgradeDB.exe should not need to be run manually unless there is a problem with the upgrade process and it needs to launched again.
If you are upgrading from a previous version of Enterprise Console the Sophos Management Service will not start until the database component has been fully upgraded. If the database component has been upgraded but the Sophos Management Service will not start following an upgrade see article 111898.
If you've spotted an error or would like to provide feedback on this article, please use the section below to rate and comment on the article. This is invaluable to us to ensure that we continually strive to give our customers the best information possible.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. For technical support post a question to the community. Or click here for new feature/product improvements. Alternatively for paid/licensed products open a support ticket.