Sophos Central Firewall Manager (CFM) maintenance scheduled for Wednesday, July 8th starting at 06:30 GMT. Expected time to complete is 5 hours. Partners will be unable to access CFM during this period.

Cannot install database - Upgrade SEC 5.5.0 to 5.5.1

Hi Guys,

 

Trying to upgrade SEC to 5.5.1 I have this error :

 

cannot install Database !!

 

The Sophos_InstallCoreDB log :

 

InstallDB (local)\SOPHOS SOPHOSSERVER SOPHOS551 "C:\ProgramData\Sophos\Management Installer\Sophos_InstallCoreDB.log"
Started
2020-02-18
09:40
==========
Msg 208, Level 16, State 1, Server SOPHOSSERVER\SOPHOS, Line 9
Invalid object name 'sysdatabases'.

 

Running on Windows server 2008 R2, Microsoft SQL Server 2008 (SP2)

  • In reply to QC:

    Hello all,

    as we've heard 5.5.2 is available. Even though it no longer supports SQL Server 2008 (all flavours) and requires at least Native Client 11 and the Copyright in CreateDatabaseWithCollation.sql has been updated it still says
    SELECT TOP 1 @lastDBName = name
    FROM sysdatabases

    Christian

  • In reply to QC:

    Bonjour Christian,

    Thanks for the info of SEC 5.5.2.

    In a couple weeks I will build 2012 or 2019 Server to migrate SEC 5.5.1 by following this procedure :

    https://community.sophos.com/kb/en-us/28276

     

    I hope will have no problems.

  • In reply to Kader:

    Hi  

    The above article should work, feel free to reach out to us for any further concerns.