Database Issue with upgrading from 5.4.1 to 5.5.0

Question

hello, 
 Today I decided to upgrade from 5.4.1 to 5.5.0 so for some reason the install went through just fine however the database did not upgrade so for this reason, services are not starting. When I click on the setup again this is the error I'm getting.

My user does have access to the database. I've been doing upgrades on this same user account. This is a sysadmin account. 
 For the second error, "The logon user cannot access the database created during a previous installation" Sophos suggested the following 
 
 Open Regedit (Start | Run Type: Regedit.exe | Press Return) 
 Browse to HKLM\Software\Sophos\EE\Management Tools\Database Installer 
 Edit the registry string 'Instance' 
 Delete the value 'MSSQLSERVER' and click OK 
 Run the Enterprise Console installer 
 
 As you can see below, I do not see the Database Installer folder or "Instance" string.

So basically now when I open Sophos Enterprise Console after a minute of it trying to connect to the server, I get the following error because the database is not upgraded.

Martin Berglund · Answer

Hello, 
 
 I also ran into this. I spent countless hour trying to figure this out. I did finally solve it though. 
 
 Here is how I did it; 
 
 1. Start SQL management studio and connect to your specific server. 
 2. Detach the SOPHOS550 database 
 3. Remove or rename the database files for SOPHOS550. They should be in "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SOPHOS\MSSQL\DATA" or something similar. 
 3. Open a command prompt and navigate to your download directory for 5.5.0, cd to ServerInstaller\DB\Core 
 4. Issue the command "InstallDB.bat (local)\SOPHOS [domain netbios name] SOPHOS550 Sophos_InstallCore550DB.log" to reinstall the 550 database. replace with your own netbios domain name and remove the []. 
 5. Do not try to run the installer, it will not work at all. 
 6. In your command prompt, navigate to your Sophos install directory. Enter the "Enterprise Console" folder. 
 7. Issue the command "UpgradeDB.exe -debug -sourceVersion=XXX" where XXX is the actual version of your previous database. Check the version number in SQL management studio. 
 
 Now, this should upgrade your previous database to the new version. 
 
 You do not need to run the installer again at this point, just simply start Enterprise Console. It should start fine. 
 
 I hope that helps.