SEC migration from a DC

Hello tstan,

to avoid misunderstandings - the server you want to install SEC on is the Hyper-V server or a VM on it? Of course you can use a VM for SEC.

Christian

Hi tstan 

Datacenter edition is supported for SEC 5.5.0, 5.5.1 and 5.5.2. Please go through the below screenshot.

Hi,

appreciate the help... a lot..

Reinstalling SQL and restarting the VM worked and the Build completed.

We continued the migration and are now in the process of protecting the endpoints from the new SEC.

It is all working on our Virtual 2016 server on our Hyper-V machine so I am not sure what wont work?

Hi tstan 

You're welcome.

Your scenario is completely supported and the build should be completed successfully as you are running Windows server 2016 may be standard edition VM on physical Hyper-V server.

Thanks for all the help with this..,, but...

Install completed and endpoints are gradually reappearing in the console.

We now want to upgrade from 550 to SEC 552.  on trying the install we get an error message on the pre check 

You don't have sufficient database rights.

I followed the /kb/en-us/124245 what to do and run the SQLCMD, the user account is in the list.

I tried to add it again and it says the server principal already exists...

this Sophos admin account is a member of Sophos DB Admins, Sophos DB Users, Domain Admins, Sophos Full and Sophos Console..

I was trying to run it from my desktop as a remote desktop session as its a VM. I ran the installer "Run as Administrator"

I also tried it on the Hyper-V server itself with the same result..

I disabled UAC through the registry with the same result.

The whole migration was done on this account..

Am I missing something else?

Hello tstan,

could you show the associated Sophos_bootstrapper log (please make sure that sensitive information is removed)? 

Christian

Hi, 

I have noticed something in this file that I missed first time..  

could this be it .. 

about a third of the way down.  On the error lines it shows SophopsServer and this should be SophosServer  I've typo'ed somewhere.

2/03/2020 13:08:02, INFO : Finished retrieving instances - Timeout
12/03/2020 13:08:17, ERROR : COM error. Connection string: Application Name=SEC Bootstrapper;Database=master;Provider=SQLNCLI11;Server=SophopsServer\SOPHOS;Trusted_Connection=Yes;DataTypeCompatibility=80; - Error: Unspecified error, Description: SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
12/03/2020 13:08:17, INFO : Checking for presence of database: SOPHOSENC51 on instance: SophopsServer\SOPHOS...
12/03/2020 13:08:34, ERROR : COM error. Connection string: Application Name=SEC Bootstrapper;Database=master;Provider=SQLNCLI11;Server=SophopsServer\SOPHOS;Trusted_Connection=Yes;DataTypeCompatibility=80; - Error: Unspecified error, Description: SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
12/03/2020 13:08:34, INFO : Installation value ID '29': ENCDBVERSION="0"

I will change the typo's in the registry and see what happens. 

Got past the first hurdle, but on to the next..

Hello tstan,

these are just warnings, simply proceed.

Christian