Error regarding existing Sophos database(s) shown during installation of Enterprise Console 5.x

  • Artikel-ID: 114097
  • Aktualisiert: 21 Aug 2014

Issue

During the installation of Enterprise Console 5.x, after choosing a SQL instance name, a 'database' account and selecting next, you see either:

  • Enterprise Console 5.0:
    Existing SOPHOS50 database found
    There is already a database called 'SOPHOS50' in the selected instance.
    Please drop it before installing Sophos Enterprise 5.0 database.

  • Enterprise Console 5.1:
    Existing database found
    There is already a database called SOPHOS51 in the selected instance. Please drop all Sophos Enterprise Console 5.1 databases before continuing.


    or

    Existing database found
    There is already a database called SOPHOSENC51 in the selected instance. Please drop all Sophos Enterprise Console 5.1 databases before continuing
    .

  • Enterprise Console 5.2:
    Existing database found
    There is already a database called [DATABASENAME] in the selected instance. Please drop all Sophos Enterprise Console 5.2 databases before continuing.


    Where:
    DATABASENAME can be: SOPHOS52, SOPHOSPATCH52, SOPHOSENC52, SophosSecurity

  • Enterprise Console 5.2.1:
    Existing database found
    There is already a database called [DATABASENAME] in the selected instance. Please drop all Sophos Enterprise Console 5.2 databases before continuing.


    Where:
    DATABASENAME can be: SOPHOS521, SOPHOSPATCH52, SOPHOSENC52, SophosSecurity

First seen in

Enterprise Console 5.0.0

Cause

The installer has checked the SQL instance you selected and found a pre-existing database on a new installation.

What To Do

You have two options:

Perform a fresh installation without saving previous data

Warning: All previously created console groups and policies will not be saved.

In this scenario you are required to ‘Drop’ (delete) the Sophos database(s) from the chosen SQL instance. After removing the existing database(s) you can continue with the installation.

Note: In the commands below .\sophos represents a local SQL Server instance with a name of 'Sophos'.  If your SQL Server instance has a different name change this part as appropriate.

  1. On the computer hosting the Sophos database role, open a command prompt (Start | Run | Type: cmd.exe | Press return).

  2. Type the appropriate command for your version of Enterprise Console and press return:

    • Console version 5.0:
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOS50"

    • Console version 5.1:
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOS51"
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOSENC51"
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOSPATCH51"

    • Console version 5.2:
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOS52"
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOSPATCH52"
      sqlcmd.exe -E -S .\sophos -Q "drop database SophosSecurity"
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOSENC52"

    • Console version 5.2.1, 5.2.1 R2, 5.2.2:
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOS521"
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOSPATCH52"
      sqlcmd.exe -E -S .\sophos -Q "drop database SophosSecurity"
      sqlcmd.exe -E -S .\sophos -Q "drop database SOPHOSENC52"

    Note: If the command completed successfully you will not see anything returned in the command prompt window. If the database you are attempting to drop does not exist run the next command in the sequence.

  3. Confirm the database(s) have been dropped from the SQL instance, type the following command and press return:
    sqlcmd.exe -E -S .\sophos -Q "select name from sys.databases"
    A list of database names attached to the SQL instance will be shown. Ensure that 'sophos50', 'sophos51' and 'sophosenc51' are not listed.

Now return to the Sophos Enterprise Console 5.x installer and complete the installation.

Save the data and import to new installation

The instructions below have been separated depending on your current version of Enterprise Console.

Note:

  • In the commands below .\sophos represents a local SQL Server instance with a name of 'Sophos'.  If your SQL Server instance has a different name change this part as appropriate.
  • For more information on the files backupdb.bat and restoredb.bat see article 110380.

Save data and import to console version 5.0

  1. Close the Enterprise Console installer.

  2. Backup your existing databases. To do so, as an administrative user, run the following two commands:
    backupdb.bat C:\windows\temp\sophos50.bak .\sophos sophos50
    backupdb.bat C:\windows\temp\sophospatch.bak .\sophos sophospatch

  3. Drop (delete) the current databases using the following command:
    sqlcmd -E -S .\sophos -Q "drop database sophos50"
    sqlcmd -E -S .\sophos -Q "drop database sophospatch"

  4. Run the Enterprise Console installer (Setup.exe located in the extraction location), choose just the "Database" component and complete the installation.

  5. Restore the databases backed up in step 2:
    restoredb.bat C:\windows\temp\sophos50.bak .\sophos sophos50
    restoredb.bat C:\windows\temp\sophospatch.bak .\sophos sophospatch

  6. Run the Enterprise Console installer (Setup.exe) and choose to add the other require components, i.e., 'Management Console' and 'Management Server' to the installation.

  7. Open Enterprise Console and ensure your previous data is available.

Note: Securely store the backed up database files currently located in the 'C:\windows\temp\' folder.

Save data and import to console version 5.1

Note: If you are using encryption, in step 6 below you will require your Master Security Officer (MSO) certificate file as exported from the previous installation..

  1. Close the Enterprise Console installer.

  2. Backup your existing databases. To do so, as an administrative user, run the following two commands:
    backupdb.bat C:\windows\temp\sophos51.bak .\sophos sophos51
    backupdb.bat C:\windows\temp\sophospatch51.bak .\sophos sophospatch51
    backupdb.bat C:\windows\temp\sophosenc51.bak .\sophos sophosenc51

  3. Drop (delete) the current databases using the following command:
    sqlcmd -E -S .\sophos -Q "drop database sophos51"
    sqlcmd -E -S .\sophos -Q "drop database sophospatch51"
    sqlcmd -E -S .\sophos -Q "drop database sophosenc51"

  4. Run the Enterprise Console installer (Setup.exe located in the extraction location), choose just the 'Database' component and complete the installation.

  5. Restore the databases backed up in step 2:
    restoredb.bat C:\windows\temp\sophos51.bak .\sophos sophos51
    restoredb.bat C:\windows\temp\sophospatch51.bak .\sophos sophospatch51
    restoredb.bat C:\windows\temp\sophosenc51.bak .\sophos sophosenc51

  6. Run the Enterprise Console installer (Setup.exe) and choose to add the other require components, i.e., 'Management Console' and 'Management Server' to the installation.

  7. Open Enterprise Console and ensure your previous data is available.

Note: Securely store the backed up database files currently located in the 'C:\windows\temp\' folder.

Save data and import to console version 5.2

Note: If you are using encryption, in step 6 below you will require your Master Security Officer (MSO) certificate file as exported from the previous installation..

  1. Close the Enterprise Console installer.

  2. Backup your existing databases. To do so, as an administrative user, run the following two commands:
    backupdb.bat C:\windows\temp\sophos52.bak .\sophos SOPHOS52
    backupdb.bat C:\windows\temp\sophospatch52.bak .\sophos SOPHOSPATCH52
    backupdb.bat C:\windows\temp\sophosenc52.bak .\sophos SOPHOSENC52
    backupdb.bat C:\windows\temp\sophossecurity.bak .\sophos SophosSecurity

  3. Drop (delete) the current databases using the following command:
    sqlcmd -E -S .\sophos -Q "drop database SOPHOS52"
    sqlcmd -E -S .\sophos -Q "drop database SOPHOSPATCH52"
    sqlcmd -E -S .\sophos -Q "drop database SOPHOSENC52"
    sqlcmd -E -S .\sophos -Q "drop database SophosSecurity"

  4. Run the Enterprise Console installer (Setup.exe located in the extraction location), choose just the 'Database' component and complete the installation.

  5. Restore the databases backed up in step 2:
    restoredb.bat C:\windows\temp\sophos52.bak .\sophos SOPHOS52
    restoredb.bat C:\windows\temp\sophospatch52.bak .\sophos SOPHOSPATCH52
    restoredb.bat C:\windows\temp\sophosenc52.bak .\sophos SOPHOSENC52
    restoredb.bat C:\windows\temp\sophossecurity.bak .\sophos SophosSecurity

  6. Run the Enterprise Console installer (Setup.exe) and choose to add the other require components, i.e., 'Management Console' and 'Management Server' to the installation.

  7. Open Enterprise Console and ensure your previous data is available.

Note: Securely store the backed up database files currently located in the 'C:\windows\temp\' folder.

Save data and import to console version 5.2.1

Note: If you are using encryption, in step 6 below you will require your Master Security Officer (MSO) certificate file as exported from the previous installation..

  1. Close the Enterprise Console installer.

  2. Backup your existing databases. To do so, as an administrative user, run the following two commands:
    backupdb.bat C:\windows\temp\sophos521.bak .\sophos SOPHOS521
    backupdb.bat C:\windows\temp\sophospatch52.bak .\sophos SOPHOSPATCH52
    backupdb.bat C:\windows\temp\sophosenc52.bak .\sophos SOPHOSENC52
    backupdb.bat C:\windows\temp\sophossecurity.bak .\sophos SophosSecurity

  3. Drop (delete) the current databases using the following command:
    sqlcmd -E -S .\sophos -Q "drop database SOPHOS521"
    sqlcmd -E -S .\sophos -Q "drop database SOPHOSPATCH52"
    sqlcmd -E -S .\sophos -Q "drop database SOPHOSENC52"
    sqlcmd -E -S .\sophos -Q "drop database SophosSecurity"

  4. Run the Enterprise Console installer (Setup.exe located in the extraction location), choose just the 'Database' component and complete the installation.

  5. Restore the databases backed up in step 2:
    restoredb.bat C:\windows\temp\sophos521.bak .\sophos SOPHOS521
    restoredb.bat C:\windows\temp\sophospatch52.bak .\sophos SOPHOSPATCH52
    restoredb.bat C:\windows\temp\sophosenc52.bak .\sophos SOPHOSENC52
    restoredb.bat C:\windows\temp\sophossecurity.bak .\sophos SophosSecurity

  6. Run the Enterprise Console installer (Setup.exe) and choose to add the other require components, i.e., 'Management Console' and 'Management Server' to the installation.

  7. Open Enterprise Console and ensure your previous data is available.

Note: Securely store the backed up database files currently located in the 'C:\windows\temp\' folder.

 
Wenn Sie weitere Informationen oder Unterstützung benötigen, wenden Sie sich bitte an den technischen Support.

Artikel bewerten

Ungenügend Hervorragend

Anmerkungen