Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 3934 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

upgrade SEC 5.0 to 5.1 with error "Invalid source version: 50"

IK

Whilst attempting to upgrade a server to SEC 5.1, I bumped into the error stating: "The Server cannot be upgraded, the database needs to be upgraded first." ..

Looking at Sophos KB article 65420 and running “UpgradeDB.exe –debug –sourceVersion=50” it comes back with an error:

C:\Program Files (x86)\Sophos\Enterprise Console>UpgradeDB.exe -debug -sourceVer
sion=50
27.09.2012 11:45:46      ... successfully completed.
27.09.2012 11:45:46 Validating parameter values ...
27.09.2012 11:45:46 Invalid source version: 50
27.09.2012 11:45:46 Exit code 1 (Invalid command line qualifier.)

In our case the regkey for the database server is pointing to the right location, albeit not the same server where SEC runs on.

Value Name: DatabaseConnectionMS
Value Data: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS50;Data Source=SQLSERVERNAME;

I've opened a case with Sophos [#3474860] and will update this thread with future steps.

:33279


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

    As QC points out...you need to create the new 5.1 databases on the database server first (by running the SEC 5.1 installer there), then when you run the 5.1 installer on the management server, upgradedb.exe will be called automatically by the management server upgrade process to move your existing data from the SOPHOS50 and SOPHOSPATCH databases to the new SOPHOS51 and SOPHOSPATCH51 databases.  Once happy you cxan drop the SOPHOS50 and SOPHOSPATCH databases becasuse they are no longer required.

    The upgrade procedure is always to upgrade the DB role first then the management server, then any remote consoles.

    Regards,

    Jak

    :33307
Reply
  • 0

    As QC points out...you need to create the new 5.1 databases on the database server first (by running the SEC 5.1 installer there), then when you run the 5.1 installer on the management server, upgradedb.exe will be called automatically by the management server upgrade process to move your existing data from the SOPHOS50 and SOPHOSPATCH databases to the new SOPHOS51 and SOPHOSPATCH51 databases.  Once happy you cxan drop the SOPHOS50 and SOPHOSPATCH databases becasuse they are no longer required.

    The upgrade procedure is always to upgrade the DB role first then the management server, then any remote consoles.

    Regards,

    Jak

    :33307
Children
No Data