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

Unable to upgrade SEC 5.0 to 5.2.1 after performing manual remote DB upgrade first

Hello all,

In the process of upgrading our SEC 5.0 server to 5.2.1 we ran into the following issue. The management server and DB server are on different dedicated nodes which has been working fine with version 5.0. Because I do not have the appropriate rights to run the DB upgrade through the 5.2.1 Installer I had to have a DBA perform the manual upgrade on the SQL Server node as described in the Sophos KB, following the Domain member upgrade steps to go from 5.0 to 5.2.1 (http://bit.ly/1gBPf0X). The DB upgrade went fine and all tables appear to have been created and access for the SOPHOS521 DB has been configured to be the same as the existing SOPHOS50 DB. Upon completion I went back to the SEC management server and re-ran the SEC 5.2.1 Installer which still states that the server cannot be upgraded:

"The server cannnot be upgraded. The database must be upgraded first."

I've verified that the remote DB configuration in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools is still set to our current SOPHOS50 DB.

I am stuck at this point and was hoping others may have encountered this issue and had some hints as to where to look next so we can complete our SEC 5.2.1 upgrade.

Thanks,

Pepijn Bruienne.

:45973


This thread was automatically locked due to age.
Parents
  • Figured it out - the user running the upgrade on the SEC node had no permissions on the MSSQL node that contains the old and new DBs. Once that user was granted temporary elevated privileges the upgrade went through without issue. Your suggestion is the correct one.

    Thanks,

    Pepijn.

    :45993
Reply
  • Figured it out - the user running the upgrade on the SEC node had no permissions on the MSSQL node that contains the old and new DBs. Once that user was granted temporary elevated privileges the upgrade went through without issue. Your suggestion is the correct one.

    Thanks,

    Pepijn.

    :45993
Children
No Data