Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 1851 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

Update Enterprise Console 3 to Enterprise Console 4

Shariar

Dear Concern,

Good Day.

We want to migrate or update our Enterprise Console (Ver -3 and DB SOPHOS3) to the latest version.

We go through sophos support doc but we fail in our test environment.

So we want your help/support/ suggestion from the very first beginning.

So we need your kind cooperation.

Thanks n Regards,

Shariar

:6629


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

    Hi,

    Is it really a transient error as the message would suggest, does this always appear or is it a one off?  

    Is it always the same error?

    Does it appear when doing something specific in SEC?

    If the management service starts and remains started it must be happily addressing the database so there can't be much wrong with the installation.  

    If it keeps failing in this way I would suggest contacting Support to maybe request the trace registry keys of the management service.That will enable you to log in far more detail what is going on with the console and the service.

    Also, just to let you know, if you run the Upgrade Advisor tool in the future it will complain that you have moved the database from the original location that was installed.  You can, as you've done just change the connection string and add in an impersonation account into the registry to get it to work but as the datasource value in the connection string, e.g.:

    Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS45;Data Source=[SERVER]\[INSTANCE];
    Does not match the original installed instance name, as stored here: 
    [HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Management Tools\Database Installer]
    "Instance"="[INSTANCE]"
    the Upgrade Advisor tool will complain.  That's not to say you need to change anything it's just more of a heads up for the future.
    To move the database to another server, you should:
    1. Install new instance.
    2. Install new SOPHOS45 database into the new instance using the installer
    3. Stop the management service on the management server.
    4. Take a backup of the SOPHOS45 database using backupd.bat for example.
    5. Restore this into the new SOPHOS45 database on the new SQL instance using restoredb.bat for example.
    6. Run the modify option on the management server SEC installer and choose to remove the database component.  In doing so it will ask for the new database location and the impersonation account for the management service to use to access the database in its new location.  Enter those details and you're done.
    Thanks,
    Jak
     
    :6985
Reply
  • 0

    Hi,

    Is it really a transient error as the message would suggest, does this always appear or is it a one off?  

    Is it always the same error?

    Does it appear when doing something specific in SEC?

    If the management service starts and remains started it must be happily addressing the database so there can't be much wrong with the installation.  

    If it keeps failing in this way I would suggest contacting Support to maybe request the trace registry keys of the management service.That will enable you to log in far more detail what is going on with the console and the service.

    Also, just to let you know, if you run the Upgrade Advisor tool in the future it will complain that you have moved the database from the original location that was installed.  You can, as you've done just change the connection string and add in an impersonation account into the registry to get it to work but as the datasource value in the connection string, e.g.:

    Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS45;Data Source=[SERVER]\[INSTANCE];
    Does not match the original installed instance name, as stored here: 
    [HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Management Tools\Database Installer]
    "Instance"="[INSTANCE]"
    the Upgrade Advisor tool will complain.  That's not to say you need to change anything it's just more of a heads up for the future.
    To move the database to another server, you should:
    1. Install new instance.
    2. Install new SOPHOS45 database into the new instance using the installer
    3. Stop the management service on the management server.
    4. Take a backup of the SOPHOS45 database using backupd.bat for example.
    5. Restore this into the new SOPHOS45 database on the new SQL instance using restoredb.bat for example.
    6. Run the modify option on the management server SEC installer and choose to remove the database component.  In doing so it will ask for the new database location and the impersonation account for the management service to use to access the database in its new location.  Enter those details and you're done.
    Thanks,
    Jak
     
    :6985
Children
No Data
Unfiltered HTML