Import registry and Secure Store

To import:

  1. Open a command prompt at the Sophos Enterprise Console installation directory.

    Windows version

    Default location

    32-bit

    C:\Program Files\Sophos\Enterprise Console

    64-bit

    C:\Program files (x86)\Sophos\Enterprise Console
  2. Type the following command to import the registry values.

    DataBackupRestore -Action=Restore -DataSourceType=Registry

    1. Confirm to continue and acknowledge any messages about files being restored.
  3. Verify the Management Service database connection string value in the registry. To do this:
    1. Open Registry Editor and go to the Sophos registry key:

      Windows version

      Default location

      32-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Management Tools\

      64-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools\
    2. In the right pane, select the entry DatabaseConnectionMS.

      Database=SOPHOS552;Provider=SQLNCLI11;

      Server=(local)\SOPHOS;Trusted_Connection=Yes;

    3. On the Edit menu, click Modify.
    4. In Value data ensure that the DataSource field is set to point to the new server hostname and SQL instance. For example (local)\SOPHOS;.

      If the SQL server instance is hosted on a remote server, substitute (local) for the server name. Check whether the database is using an existing or new instance and modify the value if needed.

  4. Modify the ServerLocation registry value to have the new server hostname. To do this.
    1. Go to the Sophos registry key:

      Windows version

      Default location

      32-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Management Tools\

      64-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools\
    2. In the right pane, select the entry ServerLocation.
    3. On the Edit menu, click Modify.
    4. In Value data, find your old server hostname, and then replace it with the new server hostname.
  5. Modify the Instance registry value to have the new server hostname. To do this:
    1. Go to the Sophos registry key:

      Windows version

      Default location

      32-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\ManagementTools\Database Installer

      64-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools\Database Installer
    2. In the right pane, select the entry Instance.
    3. On the Edit menu, click Modify.
    4. In Value data, find your old server instance name, and then replace it with the new server instance name. For example: (local)\SOPHOS;.
  6. If the database uses a workgroup or local account, modify the DatabaseUser registry value to contain the new server hostname. To do this:
    1. Go to the Sophos registry key:

      Windows version

      Default location

      32-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Management Tools\DatabaseUser

      64-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools\DatabaseUser
    2. In the right pane, select the entry DatabaseUserDomain.
    3. On the Edit menu, click Modify.
    4. In Value data, find your old server hostname, and then replace it with the new server hostname.
  7. Modify the PatchServerURL registry value to have the new server hostname and port (if a different port was set during installation). To do this:
    1. Go to the Sophos registry key:

      Windows version

      Default location

      32-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Patch\

      64-bit

      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sophos\EE\Patch\
    2. In the right pane, select the entry PatchServerURL.
    3. On the Edit menu, click Modify.
    4. In Value data, find your old server hostname, and then replace it with the new server hostname and port (if using a different port).
  8. Restore the table_router.txt file from the old server's Router folder to the new server at the following location:

    %ALLUSERSPROFILE%\Sophos\Remote Management System\3\Router\table_router.txt

  9. Restore the contents of the Envelopes from the old server's Router folder to the new server at the following location:
    %ALLUSERSPROFILE%\Sophos\Remote Management System\3\Router\Envelopes
    Note The Envelopes folder will be empty if you have no outstanding messages.
  10. Open a command prompt at the Sophos Enterprise Console installation directory.
  11. Type the following command to import Secure Store.

    DataBackupRestore -Action=Restore -DataSourceType=SecureStore

    Confirm by pressing y.

You have finished importing registry and Secure Store.