SEC 4.7 upgrade to 5.0 error

Question

Trying to upgrade out SEC to V5 but unable to update the SQL database.

when running the installed i get the following error

"The logon user cannot access the database created during a previous installation."

i have tried this as the sophos user i created when doing the original install and also as a domain admin and still get the same error.

anyone any ideas?

is there a manual way to upgrade the database as the server components of SEC go on no problem.

This thread was automatically locked due to age.

jak · Accepted Answer

Hi,

On the database machine, you just need to create the 2 'empty' databases: SOPHOS50 and SOPHOSPATCH in the SQL instance being used by Sophos. You can do this using the 2 batch files in the DB directory as unpacked by the SFX.

To create the "Core" DB (SOPHOS50) run: 
 \DB\Core\Installdb.bat .\Sophos [ContextOfSophosDBAdminsWindowsGroup] SOPHOS50 CoreDB.log 
 Then, to create the "Patch" DB run: 
 \DB\Patch\CreatePatchDb.bat .\Sophos [ContextOfSophosDBAdminsWindowsGroup] SOPHOSPATCH PatchDb.log

Where: .\Sophos represents the SQL instance. In this case a local SOPHOS named instance. 
 [ContextOfSophosDBAdminsWindowsGroup] should be the context of the windows group 'Sophos DB Admins'. So for example, if the DB role is installed on a domain member server it would be the NetBIOS name of the machine as the 'Sophos DB Admins' group would be a local group. If it was on a DC it would be the short form of the domain name. If it's in a workgroup, then it would be the machine name.

Note: When you upgrade the management server, this will execute the upgrade tool 'UpgradeDB.exe' ( http://www.sophos.com/support/knowledgebase/article/65420.html ) which will migrate the data from the SOPHOS47 database to the new SOPHOS50 database.

So in the case where the management server has already been updated you would run: 
 upgradedb.exe -debug -sourceVersion=47 Note: This tool is in the "Enterprise Console" directory on the management server and should be run from there if you've already peformed the upgrade of the management server. This will move the data to the new databases.

Regards, 
 Jak :20735