How to install the SOPHOS47 database manually

  • Article ID: 110280
  • Updated: 17 May 2012
This article explains how to manually install the database for Enterprise Console 4.7.

The SOPHOS47 database can be manually created using either:
  • the Enterprise Console installer (described in the Advanced Startup Guide)
  • using a script. This article describes how to create the SOPHOS47 database via command line scripts.

Setting up the production server

Upgrading customers

You will likely not have to set up the correct group on the server. However, if you are installing this database on a new server, you should check whether the 'Sophos DB Admins' group already exists.

If the database role is installed on a domain controller, the group should exist as a Domain Local group. If the database role exists on a member server or on a machine that is part of a workgroup, the group should be a local group.

New customers or installing on a new server

If this is a new installation, create the group 'Sophos DB Admins' on the server where you will install the database. If the server is:
  • a domain controller, do this in Active Directory and create the group with Domain local scope.
  • a member server, such as a dedicated SQL server, create a local group on the server.

    Note: In a distributed installation, where the management server role is on a different machine to the database role, the database user account as configured on the management server machine should be a member of this group.

Obtaining the installation scripts

The Enterprise Console installer can be run in Administrator mode to obtain the scripts needed to create the database. It is best to perform the steps below on a test box. The steps below should NOT be performed on a server that already has Enterprise Console installed on it.

  1. Download the installer for the version of Sophos Enterprise Console you wish to install.
  2. Double click the SFX file to launch the extraction. Extract the files, but when the Windows Installer wizard launches select Cancel. Make note of the location chosen for extraction (Default is C:\sec_47 for the current version of SEC)
  3. Click Start > Run and enter the following command:
    Msiexec /a “C:\sec_47\ServerInstaller\Sophos Enterprise Console.msi” /qn TARGETDIR=C:\SEC47FILES\
    Note: The /a switch performs an administrative install where only the file copy operations of an install are performed and no services are installed or registry changes made. The files will be extracted to a directory named C:\SEC47FILES\.
  4. Once complete, copy the folder C:\SEC47FILES\Program Files\Sophos\Enterprise Console\DB to the SQL server you wish to create the database on. This directory contains batch files and SQL scripts that are used to create the database. Where possible, use the script InstallDB.bat to install the database.

Running the installation scripts

  1. Browse to the DB folder created in the previous section (\Program Files\Sophos\Enterprise Console\DB)
  2. Run one of the following commands:

    • If you are installing the database role on a domain controller, type
      InstallDB.bat .\sophos [DomainName] [DatabaseName]

      [DomainName] should be in the domain NetBIOS name form. E.g. DOMAIN, not the full DNS name for the domain.
      [DatabaseName] in the case of installing Enterprise Console 4.7 it should be SOPHOS47. For version 4.5 it would be SOPHOS45.

    • If you are installing the database role on a member server or in a workgroup environment, type:
      InstallDB.bat .\sophos [MachineName] [DatabaseName]

      [MachineName] should be the NetBIOS name of the machine you are installing the database on.
      [DatabaseName] in the case of installing Enterprise Console 4.7 it should be SOPHOS47. For version 4.5 it would be SOPHOS45.

      For more information on parameters for the InstallDB.bat when using the default SQL instance (i.e. it has no name) please see: How to use Sophos-written batch files containing SQL commands when the SQL instance is the default instance and has no name

  3. When the command completes it will state either ‘Succeeded’ or ‘Failed’. If it failed, check the log file for further information:

    \Program Files\Sophos\Enterprise Console\DB\installDB.log

    After reading the log file, if you cannot understand why the installation failed, please contact Sophos Technical Support and let them know that you have followed this article - they will ask for your log and can help you correct any problems.

Related articles

If your installation was successful, and you need to migrate data from the previous database, please see Using upgradeDB.exe with Enterprise Console 4 or Sophos Control Center 4.

If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent