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.4.0
Enterprise Console 5.3.1
Enterprise Console 5.3.0
Enterprise Console 5.2.2
What To Do
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.
Installing/upgrading the remote database component
There are several methods for installing/upgrading the Sophos database on a different computer to the management server.
- Run the console installer (Setup.exe) on the remote SQL server and choose the database component. If you are performing an upgrade the installer will detect the existing components and perform an upgrade of them (you cannot remove components during an upgrade - use Add/Remove Programs if required)
- Creating the Sophos databases using the command line tools
This method should be used if the database components are to be installed/upgraded using scripts rather than the installer.
- Installing Enterprise Console databases in a clustered SQL Server environment
This method should be used when installing/upgrading in a clustered SQL Server environment.
Installing/upgrading the management server components
Once the Sophos Management Database component has been installed/upgraded:
- Run the installer on the console/management computer.
- Choose the components you require excluding the 'Database'.
Note: on upgrade of the management server component, you will only be presented with an 'Upgrade' button. You can skip point 3 below.
- When prompted, point to the computer and SQL server instance where you installed the Sophos database.
For more information on the database account that you will be prompted for see 113954.
- Continue with the wizard to complete the upgrade/installation.
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.