Cannot install database - Upgrade SEC 5.5.0 to 5.5.1

Hi Kader 

I have reviewed the logs provided above and found the below error:

RunScript: Custom action data: C:\Program Files\Sophos\Enterprise Console\DB\Core\;InstallDBEx.bat;(local)\SOPHOS;SCAD01MTL;SOPHOS551;C:\ProgramData\Sophos\Management Installer\Sophos_InstallCoreDB.log.
RunScript: Command line = "C:\Program Files\Sophos\Enterprise Console\DB\Core\InstallDBEx.bat" (local)\SOPHOS SCAD01MTL SOPHOS551 "C:\ProgramData\Sophos\Management Installer\Sophos_InstallCoreDB.log"
RunScript:
RunScript: C:\Program Files\Sophos\Enterprise Console\DB\Core>sqlcmd -E -S (local)\SOPHOS -b -i CreateDatabaseWithCollation.sql -v newDBName = SOPHOS551 1>>"C:\ProgramData\Sophos\Management Installer\Sophos_InstallCoreDB.log"
RunScript: Failed. See "C:\ProgramData\Sophos\Management Installer\Sophos_InstallCoreDB.log" for details.
RunScript: Error 0x80004005: Batch file returned error code 1.
CustomAction RunDBScript returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (98:A4) [09:40:35:222]: User policy value 'DisableRollback' is 0
MSI (s) (98:A4) [09:40:35:222]: Machine policy value 'DisableRollback' is 0
Action ended 09:40:35: InstallFinalize. Return value 3.

QC has already suggested you the action to perform for this error but I'd still request you to go through this article once. 

Apart from that, QC can help you more on this as I am also not commanding on SQL part. Let's wait for his reply, else I'd suggest you go ahead and open a support case and PM me the support case number.

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

Hi Christian,

Sorry for the delay, busy on another things !!! I will be back to you ASAP...Have a nice WE

Kader

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 !!

Hi Kader 

Glad to hear that your issue has been resolved.

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

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.

Hi Kader 

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