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.
Known to apply to the following Sophos product(s) and version(s) Enterprise Console 5.2.2Enterprise Console 5.3.0Enterprise Console 5.3.1Enterprise Console 5.4.0Enterprise Console 5.4.1
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.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.