Cannot install database - Upgrade SEC 5.5.0 to 5.5.1

Question

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)

Jasmin · Accepted Answer

Hi Kader 
 I am assuming that you have tried to upgrade the database from the GUI of the installer of SEC 5.5.1. 
 Please refer to this article which has a command-line method to upgrade the database for the respective version. 
 Please go through it and carefully follow the article.

QC · Answer

Hello Kader, 
 quick reply, have to leave. 
 Ar least CreateDatabaseWithCollation.sql in the ...\DB\Core\ directory uses sysdatabases as opposed to sys.databases . Might suffice to amend it there. 
 Christian

QC · Answer

Hello Kadar, 
 as far as I can see this is the only occurrence of sysdatabases and thus simply substitute sysdatabases by sys.databases . Can't say why the compatibility view is not available with your SQL instance. 
 Anyway it looks like an oversight as in all other places the system catalog views ( sys. xxxxxxx ) are used. I expect Sophos will correct it with SEC 5.5.2 or 5.6 or whatever the next version will be. 
 Christian

Kader · Answer

Bonjour Christian, 
 
 Works like a charm [:)] 
 
 I substituted sysdatabases by sys.databases in the : CreateDatabaseWithCollation.sql file located C:\sec_551\ServerInstaller\DB\Core\ 
 
 I followed the article proposed by Jasmine : https://community.sophos.com/kb/en-us/116768 
 InstallDB.bat 
 UpdatePatchDB.bat 
 and UpdateSophosSecurity.bat 
 
 Without problem, then I ran the server installer to finish the upgrading.

Merci for your help and advices !!