Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 9 replies
  • Answers 1 answer
  • Subscribers 3 subscribers
  • Views 22682 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Database Issue with upgrading from 5.4.1 to 5.5.0

sabdul

 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

  1. Open Regedit (Start | Run Type: Regedit.exe | Press Return)
  2. Browse to HKLM\Software\Sophos\EE\Management Tools\Database Installer
  3. Edit the registry string 'Instance'
  4. Delete the value 'MSSQLSERVER' and click OK
  5. 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. 



This thread was automatically locked due to age.
Parents
  • 0

    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.

Reply
  • 0

    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.

Children
  • 0 in reply to Martin Berglund

    My issue was too complicated. I tried everything you mentioned. I had to call Sophos support and had their database team step in. They ended up spending over an hour to resolve the issue. I remember when they were migrating the data over to 550, it started throwing errors which caused more issues but they fixed it.

Unfiltered HTML