Enterprise Console: moving between remote database servers

Moving the database from a local management server to a remote management server is described in Appendix B of the Sophos Endpoint Security network upgrade guide.

These notes describe how to move the database between remote database servers. They should be used in conjunction with Appendix B of the above guide.

What to do

Follow the instructions in Appendix B until you reach the section "Reconfigure the Management Services Host to point to the database on the New Database Host and uninstall the database on the Old Database Host".
Open the registry entry
HKEY_LOCAL_MACHINE\SOFTWARE\sophos\EE\Management Tools\DatabaseConnectionMS
containing the database connection string.
This is usually in the format: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS3;Data Source=[DatabaseServerHostName\DatabaseServerInstanceName];
In the connection string, replace the name of the Old Database Host with the name of the New Database Host.
For example, Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS3;Data Source=[MyNewServer/SOPHOS];
Save your changes.
Then continue with the instructions in the Appendix. The database host name will already have been replaced.

If you need more information or guidance, then please contact technical support.