Manually creating the Sophos databases for Enterprise Console as part of an install or upgrade

  • ID dell'articolo: 116768
  • Aggiornato il: 22 lug 2014

This article explains how to manually create the Sophos databases as used by Enterprise Console as part of a fresh installation or upgrade. For a list of databases per version see article: 17323.

Reasons for creating the databases manually as part of the install or upgrade include:

  • Ability to create the databases in a SQL instance remote from the installer. For example, creating the databases on a SQL cluster (covered in article 116465) or a SQL server where running installers is tightly controlled.
  • Ability to verify the SQL scripts prior to execution.

If none of the above are true you may wish to consider running the Enterprise Console server installer directly on the SQL server to automate the creation or upgrade of the Sophos databases.

The steps below cover both new installations and upgrades, choose your scenario first and then choose the role of the computer ('Domain Controller DC' or 'Domain member server or workgroup computer') hosting the SQL server for specific instructions.

Watch the video

New Installation

The following pre-requisites are required for a new installation:

  • You have already installed a SQL Server instance for Enterprise Console to use. E.g. SQL Server 2008 R2 Express and know the name of the SQL instance you wish to use. I.e. In the example: ‘SQLSERVER\SOPHOS’, SOPHOS is the instance name on computer name SQLSERVER.
  • You have the necessary rights to be able to create Windows users and groups.
  • You have the necessary rights to create databases in the SQL instance.

    Note:
    Being an administrator on the same computer as the SQL instance will typically grant you full rights over the SQL instance as the built-in Administrators group is often a member of the ‘sysadmin’ server role within SQL.

  • You have obtained the database install scripts from the server installer (running the server installer to unpack the files to a temporary location).

    Note:
    The script files required to install the databases are installed as part of the ‘database’ component. By default they are installed to: '%ProgramFiles%\Sophos\Enterprise Console\DB\'. However, when creating the databases without installing the ‘database’ component via the installer, the same 'DB' directory can also be found in the directory specified by the self-extracting executable downloaded, e.g. 'C:\sec_51\ServerInstaller\DB\'.

Domain Controller (DC)

Note: Firstly we do not recommend that you install the database role on Domain Controller (DC). Microsoft also do not recommend running SQL Server on a DC.

  1. Create a new domain local Windows security group called ‘Sophos DB Admins’.
  2. Add your Windows database account to the newly created ‘Sophos DB Admins’ group.

    Note: If you haven’t already chosen a database account see article: 113954.

  3. Run the following commands for the version of Enterprise Console you are installing in order to create the databases, substituting where required:
    • the short NetBIOS form of your domain name in place of [NetBIOSDomainName] (without the square brackets).  For example.  If your Fully Qualified Domain Name (FQDN) is builder.local, then the value the installer requires is 'builder'.
    • reference to your SQL instance in place of ‘(local)\SOPHOS’ if you are not using a local SOPHOS named SQL instance.

    • Enterprise Console 5.2.2
      • C:\sec_522\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS521 Sophos_InstallCore521DB.log
      • C:\sec_522\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_InstallSophosSecurityDB.log
      • C:\sec_522\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
      • C:\sec_522\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC52 Sophos_InstallEncDB52.log

    • Enterprise Console 5.2.1
      • C:\sec_521\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS521 Sophos_InstallCore521DB.log
      • C:\sec_521\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_InstallSophosSecurityDB.log
      • C:\sec_521\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
      • C:\sec_521\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC52 Sophos_InstallEncDB52.log

    • Enterprise Console 5.2
      • C:\sec_52\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS52 Sophos_InstallCore52DB.log
      • C:\sec_52\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_InstallSophosSecurityDB.log
      • C:\sec_52\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
      • C:\sec_52\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC52 Sophos_InstallEncDB52.log

    • Enterprise Console 5.1
      • C:\sec_51\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS51 Sophos_InstallCore51DB.log
      • C:\sec_51\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH51 Sophos_InstallPatch51DB.log
      • C:\sec_51\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC51 Sophos_InstallEnc51DB.log

    • Enterprise Console 5.0
      • C:\sec_50\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS50 Sophos_InstallCore50DB.log
      • C:\sec_50\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH Sophos_InstallPatch50DB.log

Example: To install the three databases of Enterprise Console 5.1 installation to a local SQL Server instance called SOPHOS on a domain controller for a domain called ‘domain1.local’ you would run the following three commands:

  • C:\sec_51\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS DOMAIN1 SOPHOS51 Sophos_InstallCore51DB.log
  • C:\sec_51\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS DOMAIN1 SOPHOSPATCH51 Sophos_InstallPatch51DB.log
  • C:\sec_51\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS DOMAIN1 SOPHOSENC51 Sophos_InstallEnc51DB.log
You have now installed the databases of Enterprise Console, you must now run the server installer on the management server computer to finish installing Enterprise Console.

Domain member server or workgroup computer

  1. Create a new local Windows security group called ‘Sophos DB Admins’.
  2. Add your database account to the newly created group ‘Sophos DB Admins’.

    Note: If you haven’t already chosen a database account see article: 113954.

  3. Run the following commands for the version of Enterprise Console you are installing in order to create the databases, substituting where required:
    • the short NetBIOS form of the computer name running SQL Server in place of [NetBIOSComputerName] (without the square brackets). For example. If your Fully Qualified Domain Name (FQDN) is builder.local, then the value the installer requires is 'builder'.
    • reference to your SQL instance in place of ‘(local)\SOPHOS’ if you are not using a local SOPHOS named SQL instance.

    • Enterprise Console 5.2.2
      • C:\sec_522\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS521 Sophos_InstallCore521DB.log
      • C:\sec_522\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_InstallSophosSecurityDB.log
      • C:\sec_522\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
      • C:\sec_522\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC52 Sophos_InstallEncDB52.log

    • Enterprise Console 5.2.1
      • C:\sec_521\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS521 Sophos_InstallCore521DB.log
      • C:\sec_521\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_InstallSophosSecurityDB.log
      • C:\sec_521\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
      • C:\sec_521\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC52 Sophos_InstallEncDB52.log

    • Enterprise Console 5.2
      • C:\sec_52\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS52 Sophos_InstallCore52DB.log
      • C:\sec_52\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_InstallSophosSecurityDB.log
      • C:\sec_52\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
      • C:\sec_52\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC52 Sophos_InstallEncDB.log

    • Enterprise Console 5.1
      • C:\sec_51\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS51 Sophos_InstallCore51DB.log
      • C:\sec_51\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH51 Sophos_InstallPatch51DB.log
      • C:\sec_51\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC51 Sophos_InstallEnc51DB.log

    • Enterprise Console 5.0
      • C:\sec_50\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS50 Sophos_InstallCore50DB.log
      • C:\sec_50\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH Sophos_InstallPatch50DB.log

Example: To install the three databases of a SEC 5.1 installation to a local SQL Server instance called SOPHOS on a member server called SQLSRV1 of a domain called ‘domain1.local’ you would run:

  • C:\sec_51\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS SQLSRV1 SOPHOS51 Sophos_InstallCore51DB.log
  • C:\sec_51\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS SQLSRV1 SOPHOSPATCH51 Sophos_InstallPatch51DB.log
  • C:\sec_51\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS SQLSRV1 SOPHOSENC51 Sophos_InstallEnc51DB.log
You have now installed the databases of Enterprise Console, you must now run the server installer on the management server computer to finish installing Enterprise Console.

Upgrade

The following pre-requisites are required for an upgrade to an existing installation:

  • You know the server and instance name currently in use by Enterprise Console. See article 113030 for more information.
  • You have the necessary rights to create databases in the SQL instance.

    Note:
    Being an administrator on the same computer as the SQL instance will typically grant you full rights over the SQL instance, as the built-in Administrators group is often a member of the ‘sysadmin’ server role within SQL.

  • You have obtained the database install scripts from the installer (by running the server installer to unpack the files).

Domain Controller (DC)

  1. Run the following commands for the version of Enterprise Console you are upgrading to in order to create the databases, substituting where required:
    • The short NetBIOS form of the domain name running SQL Server in place of [NetBIOSDomainName] (without the square brackets). For example. If your Fully Qualified Domain Name (FQDN) is builder.local, then the value the installer requires is 'builder'.
    • reference to your SQL instance in place of ‘(local)\SOPHOS’ if you are not using a local SOPHOS named SQL instance.

    • Enterprise Console 5.2.2
      • From 5.0
        • C:\sec_522\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_522\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_InstallSophosSecurityDB.log
        • C:\sec_522\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
        • C:\sec_522\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC52 Sophos_InstallEnc52DB.log
      • From 5.1.0
        • C:\sec_522\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_522\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_InstallSophosSecurityDB.log
        • C:\sec_522\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
        • C:\sec_521\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC52 Sophos_InstallEncDB.log
        • C:\sec_522\ServerInstaller\DB\Encryption\UpgradeEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC51 SOPHOSENC52 Sophos_UpgradeEncDB.log
      • From 5.2.0
        • C:\sec_522\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_522\ServerInstaller\DB\Patch\UpdatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_UpgradePatchDB.log
        • C:\sec_522\ServerInstaller\DB\Core\UpdateSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_UpgradeSophosSecurity.log

    • Enterprise Console 5.2.1
      • From 5.0
        • C:\sec_521\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_521\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_InstallSophosSecurityDB.log
        • C:\sec_521\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
        • C:\sec_521\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC52 Sophos_InstallEnc52DB.log
      • From 5.1.0
        • C:\sec_521\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_521\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_InstallSophosSecurityDB.log
        • C:\sec_521\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
        • C:\sec_521\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC52 Sophos_InstallEncDB.log
        • C:\sec_521\ServerInstaller\DB\Encryption\UpgradeEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC51 SOPHOSENC52 Sophos_UpgradeEncDB.log
      • From 5.2.0
        • C:\sec_521\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_521\ServerInstaller\DB\Patch\UpdatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_UpgradePatchDB.log
        • C:\sec_521\ServerInstaller\DB\Core\UpdateSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_UpgradeSophosSecurity.log

    • Enterprise Console 5.2
      • C:\sec_52\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS52 Sophos_InstallCore52DB.log
      • C:\sec_52\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSDomainName] SophosSecurity Sophos_InstallSophosSecurityDB.log
      • C:\sec_52\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
      • C:\sec_52\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC52 Sophos_InstallEncDB.log

        If you are upgrading from Enterprise Console 5.1 you also need to run the following command to upgrade the Encryption database:
      • C:\sec_52\ServerInstaller\DB\Encryption\UpgradeEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC51 SOPHOSENC52 Sophos_UpgradeEncDB.log

    • Enterprise Console 5.1
      • C:\sec_51\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS51 Sophos_InstallCore51DB.log
      • C:\sec_51\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH51 Sophos_InstallPatch51DB.log
      • C:\sec_51\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSENC51 Sophos_InstallEnc51DB.log

    • Enterprise Console 5.0
      • C:\sec_50\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOS50 Sophos_InstallCore50DB.log
      • C:\sec_50\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSDomainName] SOPHOSPATCH Sophos_InstallPatch50DB.log

Example: To install the three databases of a Enterprise Console 5.1 upgrade to a local SQL Server instance called SOPHOS on a domain controller for a domain called ‘domain1.local’ you would run:

  • C:\sec_51\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS DOMAIN1 SOPHOS51 Sophos_InstallCore51DB.log
  • C:\sec_51\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS DOMAIN1 SOPHOSPATCH51 Sophos_InstallPatch51DB.log
  • C:\sec_51\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS DOMAIN1 SOPHOSENC51 Sophos_InstallEnc51DB.log

You have now installed the databases of the new version of Enterprise Console you are upgrading to, you must now run the server installer on the management server computer to finish upgrading Enterprise Console.  

Important: It is the upgrade of the management server role which moves the data from the current databases to the new databases.  

Domain member server or workgroup

  1. Run the following commands for the version of Enterprise Console you are upgrading to in order to create the databases, substituting where required:
    • the short NetBIOS form of the computer name running SQL Server in place of [NetBIOSComputerName] (without the square brackets).  For example. If your Fully Qualified Domain Name (FQDN) is builder.local, then the value the installer requires is 'builder'.
    • reference to your SQL instance in place of ‘(local)\SOPHOS’ if you are not using a local SOPHOS named SQL instance.

    • Enterprise Console 5.2.2
      • From 5.0
        • C:\sec_522\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_522\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_InstallSophosSecurityDB.log
        • C:\sec_522\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
        • C:\sec_522\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC52 Sophos_InstallEnc52DB.log
      • From 5.1.0
        • C:\sec_522\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_522\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_InstallSophosSecurityDB.log
        • C:\sec_522\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
        • C:\sec_522\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC52 Sophos_InstallEncDB.log
        • C:\sec_522\ServerInstaller\DB\Encryption\UpgradeEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC51 SOPHOSENC52 Sophos_UpgradeEncDB.log
      • From 5.2.0
        • C:\sec_522\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_522\ServerInstaller\DB\Patch\UpdatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_UpgradePatchDB.log
        • C:\sec_522\ServerInstaller\DB\Core\UpdateSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_UpgradeSophosSecurity.log

    • Enterprise Console 5.2.1
      • From 5.0
        • C:\sec_521\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_521\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_InstallSophosSecurityDB.log
        • C:\sec_521\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
        • C:\sec_521\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC52 Sophos_InstallEnc52DB.log
      • From 5.1.0
        • C:\sec_521\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_521\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_InstallSophosSecurityDB.log
        • C:\sec_521\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
        • C:\sec_521\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC52 Sophos_InstallEncDB.log
        • C:\sec_521\ServerInstaller\DB\Encryption\UpgradeEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC51 SOPHOSENC52 Sophos_UpgradeEncDB.log
      • From 5.2.0
        • C:\sec_521\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS521 Sophos_InstallCore521DB.log
        • C:\sec_521\ServerInstaller\DB\Patch\UpdatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_UpgradePatchDB.log
        • C:\sec_521\ServerInstaller\DB\Core\UpdateSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_UpgradeSophosSecurity.log

    • Enterprise Console 5.2
      • C:\sec_52\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS52 Sophos_InstallCore52DB.log
      • C:\sec_52\ServerInstaller\DB\Core\InstallSophosSecurity.bat (local)\SOPHOS [NetBIOSComputerName] SophosSecurity Sophos_InstallSophosSecurityDB.log
      • C:\sec_52\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH52 Sophos_InstallPatch52DB.log
      • C:\sec_52\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC52 Sophos_InstallEncDB.log

        If you are upgrading from Enterprise Console 5.1 you also need to run the following command to upgrade the Encryption database:
      • C:\sec_52\ServerInstaller\DB\Encryption\UpgradeEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC51 SOPHOSENC52 Sophos_UpgradeEncDB.log

    • Enterprise Console 5.1
      • C:\sec_51\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS51 Sophos_InstallCore51DB.log
      • C:\sec_51\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH51 Sophos_InstallPatch51DB.log
      • C:\sec_51\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSENC51 Sophos_InstallEnc51DB.log

    • Enterprise Console 5.0
      • C:\sec_50\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOS50 Sophos_InstallCore50DB.log
      • C:\sec_50\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS [NetBIOSComputerName] SOPHOSPATCH Sophos_InstallPatch50DB.log

Example: To install the three databases of a SEC 5.1 upgrade to a local SQL Server instance called SOPHOS on a member server called SQLSRV1 of a domain called ‘domain1.local’ you would run:

  • C:\sec_51\ServerInstaller\DB\Core\InstallDB.bat (local)\SOPHOS DOMAIN1 SOPHOS51 Sophos_InstallCore51DB.log
  • C:\sec_51\ServerInstaller\DB\Patch\CreatePatchDB.bat (local)\SOPHOS DOMAIN1 SOPHOSPATCH51 Sophos_InstallPatch51DB.log
  • C:\sec_51\ServerInstaller\DB\Encryption\InstallEncryptionDB.bat (local)\SOPHOS DOMAIN1 SOPHOSENC51 Sophos_InstallEnc51DB.log

You have now installed the databases of the new version of Enterprise Console you are upgrading to, you must now run the server installer on the management server computer to finish upgrading Enterprise Console.

Important: It is the upgrade of the management server role which moves the data from the current databases to the new databases.

 
Per maggiori informazioni o per assistenza, vi preghiamo di contattare il supporto tecnico.

Valutate l'articolo

Molto scadente Eccellente

Commenti