Enterprise Console frozen after Server to Server Migration

Question

Hello,

I'm migrating a Enterprise Console 4.7 from an W2k8 server machine to an W2K-R2 server machine (SEC 4.7 to SEC 4.7).

I'm doing this like it is discribed in the "server to server migration guide" (sec_4_mgeng.pdf).

All worked great, until I finished importing database, registry keys, and private store (Chapter 11, Page 17 in sec_4_meng.pdf)

and try to start SEC. It comes up without any error, shows all clients, policies, etc. but is frozen dead.

I can't do anything with SEC but killing it from the taskmanager.

hints welcome.

Kind regards

Joerg

This thread was automatically locked due to age.

JSCR · Accepted Answer

Hello Christian, I just solved it. I rolled back the new SEC Server machine to the point, where I have to start with the database import, copied the CID-Folder from the old SEC-Server to the new one and restarted the import and all following steps. Now Enterprise Console is running. Just coping the CID-Folder and restarting the machine did not solve the problem. kind regards, Joerg :36165

HirscherTechnik · Answer

Since being 20 minutes on hold with Sophos Support, I figured out myself what there is to delete in the SQL-DB. 
 
 Install correct SQL Management Studio (download? use Google :-) ), 
 in my case it was SQL 2012 affecting SEC 5.4 on new Server 2012R2 migrating from 2008. 
 
 Then login into SQL Management Studio 
 
 Go for Databases > Sophos540 (or corresponding to your Version) > Tables > dbo.SDDMServers 
 Rightclick onto SDDMServers > Select Top 1000 Rows 
 There should be two entries (or if you have many SUM-Installations, at least you find the wrong one here) 
 Create a DB-Backup!!! 
 Rightclick onto SDDMServers > Edit Top 200 Rows 
 Select the whole row by clicking into the field before the ID-Field. 
 Rightclick > Delete or Press DEL 
 Changes are made immediately! 
 
 After that, start SEC, should be asking for Licence information. 
 
 Hope that helps! 
 (besides, i just hangup the phone since no one answers. you guys need to reduce waiting time....)

TheJ0ker · Answer

Hi Joerg, 
 i was having the same issue with SEC 5.5 on Windows Server 2012 R2 and got a call with Sophos. 
 The solution was very easy for me: 
 Set Server Region to english (great britain) and thats all. SEC started without problems. When migration is done, you can set the region back to your needs.