Enterprise Console Migration

Hi,

Many thanks for your reply jak, and apologies to all for not updating this thread earlier.  The issue of migrating SEC did get pushed aside for a while and has only now come back to haunt me.

Your suggestion of manually importing the databases did allow me to proceed, so thanks again for the advice.  However, it's not all quite plain sailing yet :smileysad:  If anyone has any advice for the following situation it would be much appreciated!

Basically I'm now at the stage where everything has (allegedly) migrated over successfully, but when starting Enterprise Console on the new server for the first time the following error is displayed:

Sophos.UIController.Extension.UIControllerException: Cannot retrieve session token after 8 retries. Please check that the Sophos Management Host service is running, otherwise see KBA 118513.
   at Sophos.UIController.IdentityServiceAbstracter.EndRetrieveSessionToken()
   at Sophos.UIController.UIControl.InitializeModulesDependencies()
   at Sophos.UIController.UIControl.<Initialize>b__b()
   at Sophos.UIController.Product.Logging.LogMethod(MemberInfo method, Action func)
   at Sophos.UIController.UIControl.Initialize()

----- [outer exception] -----
   -- error: 0x80004005 (Unspecified error)
   -- facility: Generic (System)
   -- source:   Sophos.UIController

   at class ATL::CComBSTR __thiscall UIControl::initialize(class ATL::CComPtr<struct IDispatch>)
   at class ATL::CComPtr<struct IDispatch> __thiscall bl::CReusingManagementServiceClientBroker::logIn(const struct util::UserName &,class Loki::SmartPtr<class bl::SubEstate,class Loki::RefCountedMTAdj<class Loki::ClassLevelLockable>::RefCountedMT,struct Loki::DisallowConversion,struct util::NoDereferenceNull,class Loki::DefaultSPStorage>,const wchar_t *,class bl::UIControllerBase &)
   at int __cdecl Run(int,class bl::CommandLine,enum bl::ConsoleType::Type)
   at int __stdcall wWinMain(struct HINSTANCE__ *,struct HINSTANCE__ *,wchar_t *,int)

I've gone through all the steps listed in the knowledgebase article and have verified that the services are all running, and using the database account specified during installation.  The SophosSecurity database is present and online, and the database account is in the "Sophos DB Admins" group (I even tried testing the service with the domain admin account, just to verify permissions, and this also failed).  Networking on the server is all fine, and I've run out of things to try now.

I'm assuming other people have managed to migrate SEC to a new server without these problems, and I've either missed something or am being incredibly stupid with the entire process?  If anyone has any ideas what I am missing or doing wrong, they'd be much appreciated!

Thanks in advance.

(Edited to fix typos)

Hi,

Many thanks for your reply jak, and apologies to all for not updating this thread earlier.  The issue of migrating SEC did get pushed aside for a while and has only now come back to haunt me.

Your suggestion of manually importing the databases did allow me to proceed, so thanks again for the advice.  However, it's not all quite plain sailing yet :smileysad:  If anyone has any advice for the following situation it would be much appreciated!

Basically I'm now at the stage where everything has (allegedly) migrated over successfully, but when starting Enterprise Console on the new server for the first time the following error is displayed:

Sophos.UIController.Extension.UIControllerException: Cannot retrieve session token after 8 retries. Please check that the Sophos Management Host service is running, otherwise see KBA 118513.
   at Sophos.UIController.IdentityServiceAbstracter.EndRetrieveSessionToken()
   at Sophos.UIController.UIControl.InitializeModulesDependencies()
   at Sophos.UIController.UIControl.<Initialize>b__b()
   at Sophos.UIController.Product.Logging.LogMethod(MemberInfo method, Action func)
   at Sophos.UIController.UIControl.Initialize()

----- [outer exception] -----
   -- error: 0x80004005 (Unspecified error)
   -- facility: Generic (System)
   -- source:   Sophos.UIController

   at class ATL::CComBSTR __thiscall UIControl::initialize(class ATL::CComPtr<struct IDispatch>)
   at class ATL::CComPtr<struct IDispatch> __thiscall bl::CReusingManagementServiceClientBroker::logIn(const struct util::UserName &,class Loki::SmartPtr<class bl::SubEstate,class Loki::RefCountedMTAdj<class Loki::ClassLevelLockable>::RefCountedMT,struct Loki::DisallowConversion,struct util::NoDereferenceNull,class Loki::DefaultSPStorage>,const wchar_t *,class bl::UIControllerBase &)
   at int __cdecl Run(int,class bl::CommandLine,enum bl::ConsoleType::Type)
   at int __stdcall wWinMain(struct HINSTANCE__ *,struct HINSTANCE__ *,wchar_t *,int)

I've gone through all the steps listed in the knowledgebase article and have verified that the services are all running, and using the database account specified during installation.  The SophosSecurity database is present and online, and the database account is in the "Sophos DB Admins" group (I even tried testing the service with the domain admin account, just to verify permissions, and this also failed).  Networking on the server is all fine, and I've run out of things to try now.

I'm assuming other people have managed to migrate SEC to a new server without these problems, and I've either missed something or am being incredibly stupid with the entire process?  If anyone has any ideas what I am missing or doing wrong, they'd be much appreciated!

Thanks in advance.

(Edited to fix typos)