cannot validate the logon user account against the domain controller

Having recently taken over the admin of our Sophos, there is a message on the VM hosting the SEC that

Sophos Enterprise Console (SEC) is not supported

Your SEC version 5.4.0 is not supported. Please update the SEC to the latest version 5.5.1.

 

Initially I tried to install version 5.5.1 but it failed and on further reading the upgrade path suggests upgrading to 5.4.1 first, which is what I am trying to do.

After dealing with the other requirements, I am left with one 'cannot validate the logon user account against the domain controller''

I have checked the AD on the domain controller does have the User Accounts Sophos Management and SophosUpdateMgr and they have the attributes recommended in your notes.

This is on Windows Server 2012 R2

What is the next step please?

thanks
Mark

  • Hello Mark,

    first of all, upgrading to 5.4.1 first should not be necessary. Direct upgrade to 5.5.1 should be possible from any 5.x version.

    dealing with the other requirements
    IIRC there aren't any special. To upgrade from 5.4.0 you basically just run the installer - what requirements are you referring to?
    cannot validate the logon user account

    at which step do you get this message? Could you perhaps provide a screenshot?
    [Edit]An explanation of this check that fails is here[/Edit]

    The database is local or remote and do you know the SQL Server version in use? Furthermore, the account with which you attempt to upgrade was taken over from the previous admin or is a new one?

    Christian

  • Thanks Christian

    Initially I tried to install version 5.5.1 but it failed and on further reading the Sophos upgrade path suggests upgrading to 5.4.1 first, which is what I am trying to do.

    This is what happens when trying to install 5.4.1

    This is what happens when I try to install 5.5.1 as you suggest 

     

    You asked dealing with the other requirements

    I am referring to the other System Property Checks. Initially when I ran 5.5.1 there were others it failed and I took the appropriate action.

    You asked cannot validate the logon user account, at which step do you get this message? 

    This is the only System Property Check that it fails on installing 5.4.1 and one of two it fails on 5.5.1 

    You asked The database is local or remote 

    As far as I know it was all installed on the local machine

    You asked the account with which you attempt to upgrade was taken over from the previous admin or is a new one

    I am logged in as the domain administrator account

    You asked do you know the SQL Server version in use

    According to programs and Features there are SQL Server 2012, 2014 & 2017 components installed

     

    thanks
    Mark

  • In reply to Mark Burchett:

    Hello Mark.

    where does something suggest to upgrade to 5.4.1 first?

    Anyway, that you get two messages for 5.5.1 suggests that the database is remote (or at least the installer assumes it is). Please check the HKLM\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools\DatabaseConnectionMS registry value.

    Can't say what's causing the validate error. Hm ...

    Christian

  • In reply to QC:

    Thanks Christian

    The HKLM\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools\DatabaseConnectionMS registry value is
    Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS540;Data Source=(local)\SOPHOS;

    Mark

  • In reply to Mark Burchett:

    Hello Mark,

    too long since I've played with the Database component, can't remember the details. Now indeed it's pointing to the local instance (and apparently this works). Nevertheless the prerequisite checker behaves as if it were a remote database. IIRC this is because the Database component doesn't appear to be installed (i.e. it's not under Programs and Features) - the Sophos_bootstrapper dd-mm-yyyy hh_mm_ss.log (in %ProgramData%\Sophos\Management Installer\) should confirm this. After 20 lines or so there's normally
    INFO : SEC Console detected.
    INFO : SEC Server detected.
    INFO : SEC Database detected.
    INFO : SUM detected.
    I assume it doesn't list the database. If so, please use the following command (assuming a 64bit OS) to install the missing component (note: it's not about files, database instance, or actual database but what the Windows Installer knows or doesn't know about this product):
    msiexec /i"C:\sec_540\ServerInstaller\Database64.msi" DATABASE_SERVERNAME="(local)\SOPHOS" DATABASE_USERNAME="SophosManagement" DATABASE_USERNAMEDOMAIN="Domain" INSTALLDIR="C:\Program Files (x86)\Sophos" CREATE_DATABASES=0
    The DATABASE_USERNAME and DATABASE_USERNAMEDOMAIN should be the values from the HKLM\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools\DatabaseUser key.

    The same bootstrapper log should also give some hint regarding the validate error.

    Christian

  • In reply to QC:

    Many thanks Christian.

    It didn't quite have those statements around line 20, (I've uploaded the complete file) but much further in the document there were these

    0/01/2019 14:16:52, INFO : Checking for presence of database: SOPHOS551 on instance: (local)\SOPHOS...
    30/01/2019 14:16:52, INFO : Database: SOPHOS551 does not exist on instance: (local)\SOPHOS
    30/01/2019 14:16:52, ERROR : There is not a SOPHOS551 database in the remote instance. Need to upgrade database first
    30/01/2019 14:16:52, ERROR : System Property Check: Checking database account for server upgrade - FAILED

    Sophos_bootstrapper 30-01-2019 14_15_53.log
    Started Setup.exe, located at: C:\Temp\sec_551\ServerInstaller
    30/01/2019 14:15:53, INFO : Verifying files in folder
    30/01/2019 14:15:53, INFO : Target folder verification completed successfully
    30/01/2019 14:15:53, INFO : Initialized COM in the main thread
    30/01/2019 14:15:53, INFO : The Winsock 2.2 dll was found okay.
    30/01/2019 14:15:53, INFO : --------System Information------------
    30/01/2019 14:15:53, INFO : Computer Name: GEMAPP
    30/01/2019 14:15:53, INFO : Operating System: 6.2.0 
    30/01/2019 14:15:53, INFO : Service Pack: 0
    30/01/2019 14:15:53, INFO : System Type: 64 bit Operating System
    30/01/2019 14:15:53, INFO : Locale: en
    30/01/2019 14:15:53, INFO : Logged-on User: GEM\Administrator
    30/01/2019 14:15:53, INFO : Domain: GEM
    30/01/2019 14:15:53, INFO : --------------------------------------
    30/01/2019 14:15:53, INFO : Detected MSI version: 5.0.9600
    30/01/2019 14:15:53, INFO : Activate state: Idle
    30/01/2019 14:15:53, INFO : Obtaining SQL instances on local machine...
    30/01/2019 14:15:53, INFO : Computer is joined to domain: GEM
    30/01/2019 14:15:53, INFO : Found MSI: \Console64.msi version: 5.5.1
    30/01/2019 14:15:53, INFO : Found installed component: {6EF27BE8-9977-4682-A487-5F2B01AF5BFA} version: 5.4.0
    30/01/2019 14:15:54, INFO : Found MSI: \Server64.msi version: 5.5.1
    30/01/2019 14:15:54, INFO : Found MSI: \Database64.msi version: 5.5.1
    30/01/2019 14:15:54, INFO : Found installed component: {2C7A82DB-69BC-4198-AC26-BB862F1BE4D0} version: 1.5.8.11
    30/01/2019 14:15:54, INFO : Found MSI: SUM.msi version: 1.6.2.186
    30/01/2019 14:15:54, INFO : SEC Server detected.
    30/01/2019 14:15:54, INFO : SUM detected.
    30/01/2019 14:15:54, INFO : Upgrade 5.x workflow
    30/01/2019 14:15:54, INFO : Changed installation value: INSTALLDIR="C:\Program Files\Sophos" INSTALLDIR32="C:\Program Files (x86)\Sophos" SUM_INSTALLDIR="C:\Program Files (x86)\Sophos\Update Manager" 
    30/01/2019 14:15:54, INFO : Changed installation value: UPGRADE="1" 
    30/01/2019 14:15:54, INFO : Changed installation value: SERVER_PORT="80" 
    30/01/2019 14:15:54, INFO : Changed installation value: SERVER_USERNAME="SophosManagement" 
    30/01/2019 14:15:54, INFO : Changed installation value: SERVER_USERNAMEDOMAIN="GEM" 
    30/01/2019 14:15:54, INFO : Changed installation value: SERVER_USERNAMEPASSWORD="********" 
    30/01/2019 14:15:54, INFO : upn found: SophosManagement@gem.local
    30/01/2019 14:15:54, INFO : Changed installation value: SERVER_UPN="SophosManagement@gem.local" 
    30/01/2019 14:15:54, INFO : Database account known. Database page will not be displayed
    30/01/2019 14:15:54, INFO : Changed installation value: DATABASE_SERVERNAME="(local)\SOPHOS" DATABASE_CONNECTIONSTRING="" 
    30/01/2019 14:15:54, INFO : Changed installation value: SERVER_FEEDBACKENABLED="1" 
    30/01/2019 14:15:54, INFO : Changed installation value: 
    30/01/2019 14:15:54, INFO : Changed installation value: 
    30/01/2019 14:15:54, INFO : Changed installation value: DB_UPGRADE_VERSION="540" 
    30/01/2019 14:15:54, INFO : Checking for presence of database: SOPHOSENC52 on instance: ...
    30/01/2019 14:15:54, INFO : Finished retrieving instances - Timeout
    30/01/2019 14:15:54, INFO : Obtaining remote SQL instances on network...
    30/01/2019 14:15:55, INFO : Finished retrieving instances - Timeout
    30/01/2019 14:16:12, ERROR : COM error. Connection string: Provider='sqloledb'; Data Source=''; Initial Catalog='master'; Integrated Security='SSPI'; - Error: Unspecified error, Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
    30/01/2019 14:16:12, INFO : Checking for presence of database: SOPHOSENC51 on instance: ...
    30/01/2019 14:16:29, ERROR : COM error. Connection string: Provider='sqloledb'; Data Source=''; Initial Catalog='master'; Integrated Security='SSPI'; - Error: Unspecified error, Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
    30/01/2019 14:16:29, INFO : Changed installation value: ENCDBVERSION="0" 
    30/01/2019 14:16:29, INFO : Entered Welcome page.
    30/01/2019 14:16:47, INFO : Running System Property Check: User must be an administrator on this computer...
    30/01/2019 14:16:47, INFO : System Property Check: User must be an administrator on this computer - PASSED
    30/01/2019 14:16:47, INFO : Running System Property Check: All SEC components installed must be the same version...
    30/01/2019 14:16:47, INFO : Found MSI: \Console64.msi version: 5.5.1
    30/01/2019 14:16:47, INFO : Found installed component: {6EF27BE8-9977-4682-A487-5F2B01AF5BFA} version: 5.4.0
    30/01/2019 14:16:48, INFO : Found MSI: \Server64.msi version: 5.5.1
    30/01/2019 14:16:48, INFO : Found MSI: \Database64.msi version: 5.5.1
    30/01/2019 14:16:48, INFO : Found installed component: {2C7A82DB-69BC-4198-AC26-BB862F1BE4D0} version: 1.5.8.11
    30/01/2019 14:16:48, INFO : Found MSI: SUM.msi version: 1.6.2.186
    30/01/2019 14:16:48, INFO : System Property Check: All SEC components installed must be the same version - PASSED
    30/01/2019 14:16:48, INFO : Entered Eula page.
    30/01/2019 14:16:49, INFO : Accepted Eula.
    30/01/2019 14:16:50, INFO : Running System Property Check: Support operating system version and service pack must be installed...
    30/01/2019 14:16:50, INFO : Version: 6.2.0 SP: 0 Architecture: 2 Edition: 7
    30/01/2019 14:16:50, INFO : OS version 6.2 Service pack installed
    30/01/2019 14:16:50, INFO : System Property Check: Support operating system version and service pack must be installed - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Encryption must be not installed...
    30/01/2019 14:16:50, INFO : System Property Check: Encryption must be not installed - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: System account must be able to impersonate other accounts...
    30/01/2019 14:16:50, INFO : System Property Check: System account must be able to impersonate other accounts - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Machine name should not exceed 15 characters...
    30/01/2019 14:16:50, INFO : System Property Check: Machine name should not exceed 15 characters - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Computer should have only one network adapter to ensure that RMS binds correctly...
    30/01/2019 14:16:50, INFO : System Property Check: Computer should have only one network adapter to ensure that RMS binds correctly - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Computer must be rebooted (Installer runonce key or SGN localCache detected) - Computer should be rebooted (warning if there are pending rename operations)...
    30/01/2019 14:16:50, WARNING : System Property Check: Computer must be rebooted (Installer runonce key or SGN localCache detected) - Computer should be rebooted (warning if there are pending rename operations) - FAILED
    30/01/2019 14:16:50, INFO : Running System Property Check: Computer should have more than 4GB RAM...
    30/01/2019 14:16:50, INFO : System Property Check: Computer should have more than 4GB RAM - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Operating system should support more than 5000 clients...
    30/01/2019 14:16:50, INFO : System Property Check: Operating system should support more than 5000 clients - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: SEC 1.x, 2.0 or 3.x must not be installed on this computer...
    30/01/2019 14:16:50, INFO : Product is not installed on local system. Upgrade code: {AC0DE50E-751A-4081-8F5B-8DC7ACBBBD4A}
    30/01/2019 14:16:50, INFO : SEC 2.x is not installed on local system. MsiQueryProductState return -1
    30/01/2019 14:16:50, INFO : SEC 3.x is not installed on local system. MsiQueryProductState return -1
    30/01/2019 14:16:50, INFO : System Property Check: SEC 1.x, 2.0 or 3.x must not be installed on this computer - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Sophos Help Desk must not be installed on this computer...
    30/01/2019 14:16:50, INFO : Product is not installed on local system. Upgrade code: {4ED6795A-1166-4277-B059-5189544286FE}
    30/01/2019 14:16:50, INFO : System Property Check: Sophos Help Desk must not be installed on this computer - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Sophos Control Center 2.x must not be installed on this computer...
    30/01/2019 14:16:50, INFO : Product is not installed on local system. Upgrade code: {99D634CF-54AF-4FCD-8259-AF8BAA7E7FC5}
    30/01/2019 14:16:50, INFO : System Property Check: Sophos Control Center 2.x must not be installed on this computer - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Simple file sharing must be disabled...
    30/01/2019 14:16:50, INFO : System Property Check: Simple file sharing must be disabled - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Sophos EM Console must not be installed on this computer...
    30/01/2019 14:16:50, INFO : Product is not installed on local system. Upgrade code: {32FF7557-4C84-4E2E-B917-EE09D8E59FDE}
    30/01/2019 14:16:50, INFO : System Property Check: Sophos EM Console must not be installed on this computer - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Sophos EM Library must not be installed on this computer...
    30/01/2019 14:16:50, INFO : Product is not installed on local system. Upgrade code: {7A81AAEB-E07D-4E38-A36B-9B91FA0BA578}
    30/01/2019 14:16:50, INFO : System Property Check: Sophos EM Library must not be installed on this computer - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: This computer should have at least 8GB free disk space on the primary drive...
    30/01/2019 14:16:50, INFO : Enough space: 25374.000000 Mb
    30/01/2019 14:16:50, INFO : System Property Check: This computer should have at least 8GB free disk space on the primary drive - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: SEC should not be installed on a Domain Controller...
    30/01/2019 14:16:50, INFO : The computer is not a Domain Controller
    30/01/2019 14:16:50, INFO : System Property Check: SEC should not be installed on a Domain Controller - PASSED
    30/01/2019 14:16:50, INFO : Running System Property Check: Logged on user must have rights to query the accounts used by the existing installation...
    30/01/2019 14:16:52, INFO : System Property Check: Logged on user must have rights to query the accounts used by the existing installation - PASSED
    30/01/2019 14:16:52, INFO : Running System Property Check: Checking database account for server upgrade...
    30/01/2019 14:16:52, INFO : Checking for presence of database: SOPHOS551 on instance: (local)\SOPHOS...
    30/01/2019 14:16:52, INFO : Database: SOPHOS551 does not exist on instance: (local)\SOPHOS
    30/01/2019 14:16:52, ERROR : There is not a SOPHOS551 database in the remote instance. Need to upgrade database first
    30/01/2019 14:16:52, ERROR : System Property Check: Checking database account for server upgrade - FAILED
    30/01/2019 14:16:52, INFO : Running System Property Check: .NET 3.5 SP1 must be installed and the computer restarted before installing on Windows 2008 SP1...
    30/01/2019 14:16:52, INFO : System Property Check: .NET 3.5 SP1 must be installed and the computer restarted before installing on Windows 2008 SP1 - PASSED
    30/01/2019 14:16:52, INFO : Running System Property Check: The logged on user must be able to connect to the domain controller in Active Directory...
    30/01/2019 14:16:52, ERROR : System Property Check: The logged on user must be able to connect to the domain controller in Active Directory - FAILED
    30/01/2019 14:16:52, INFO : Running System Property Check: All subscriptions must be either recommended or previous tags...
    30/01/2019 14:16:52, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS540;Data Source=(local)\SOPHOS;
    30/01/2019 14:16:52, INFO : Executing query...
    30/01/2019 14:16:53, INFO : System Property Check: All subscriptions must be either recommended or previous tags - PASSED
    30/01/2019 14:16:53, INFO : Running System Property Check: SUM subscription must be set to 'Recommended'...
    30/01/2019 14:16:53, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS540;Data Source=(local)\SOPHOS;
    30/01/2019 14:16:53, INFO : Executing query...
    30/01/2019 14:16:53, INFO : System Property Check: SUM subscription must be set to 'Recommended' - PASSED
    30/01/2019 14:16:53, INFO : Running System Property Check: All subscriptions should have autosubscribe enabled...
    30/01/2019 14:16:53, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS540;Data Source=(local)\SOPHOS;
    30/01/2019 14:16:53, INFO : Executing query...
    30/01/2019 14:16:53, INFO : System Property Check: All subscriptions should have autosubscribe enabled - PASSED
    30/01/2019 14:16:53, INFO : Running System Property Check: Endpoints with old RMS cannot handle SHA2 therefore they will not be able to communicate with management console...
    30/01/2019 14:16:53, INFO : Checking MAC endpoints...
    30/01/2019 14:16:53, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS540;Data Source=(local)\SOPHOS;
    30/01/2019 14:16:53, INFO : Executing query...
    30/01/2019 14:16:53, INFO : Checking UNIX endpoints...
    30/01/2019 14:16:53, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS540;Data Source=(local)\SOPHOS;
    30/01/2019 14:16:53, INFO : Executing query...
    30/01/2019 14:16:53, INFO : Checking VSHIELD endpoints...
    30/01/2019 14:16:53, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS540;Data Source=(local)\SOPHOS;
    30/01/2019 14:16:53, INFO : Executing query...
    30/01/2019 14:16:53, INFO : Checking LINUX endpoints...
    30/01/2019 14:16:53, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS540;Data Source=(local)\SOPHOS;
    30/01/2019 14:16:53, INFO : Executing query...
    30/01/2019 14:16:53, INFO : System Property Check: Endpoints with old RMS cannot handle SHA2 therefore they will not be able to communicate with management console - PASSED
    30/01/2019 14:16:53, INFO : Entered PreChecks page.
    30/01/2019 14:26:57, INFO : Clicked Cancel button
    30/01/2019 14:26:58, INFO : Confirmed cancellation of the bootstrapper
    30/01/2019 14:26:58, INFO : Cancel state: Idle
    30/01/2019 14:26:58, INFO : Deactivate state: Idle
    30/01/2019 14:26:58, INFO : Activate state: Cancelled
    30/01/2019 14:26:58, INFO : Canceled wizard.
    30/01/2019 14:27:00, INFO : Finished Bootstrapper
    30/01/2019 14:27:00, INFO : Cleaned up socket.
    30/01/2019 14:27:00, INFO : Uninitialized COM in main thread
    

    So I followed your instructions to install the Database, which ran okay. However, when I ran the upgrade installer getting this error

    This is bootstrapper after running the Database installer.

    Sophos_bootstrapper 31-01-2019 15_06_17.log
    Started Setup.exe, located at: C:\Temp\sec_541\ServerInstaller
    31/01/2019 15:06:17, INFO : Verifying files in folder
    31/01/2019 15:06:17, INFO : Target folder verification completed successfully
    31/01/2019 15:06:17, INFO : Initialized COM in the main thread
    31/01/2019 15:06:17, INFO : The Winsock 2.2 dll was found okay.
    31/01/2019 15:06:17, INFO : --------System Information------------
    31/01/2019 15:06:17, INFO : Computer Name: GEMAPP
    31/01/2019 15:06:17, INFO : Operating System: 6.2.0 
    31/01/2019 15:06:17, INFO : Service Pack: 0
    31/01/2019 15:06:17, INFO : System Type: 64 bit Operating System
    31/01/2019 15:06:17, INFO : Locale: en
    31/01/2019 15:06:17, INFO : Logged-on User: GEM\Administrator
    31/01/2019 15:06:17, INFO : Domain: GEM
    31/01/2019 15:06:17, INFO : --------------------------------------
    31/01/2019 15:06:17, INFO : Detected MSI version: 5.0.9600
    31/01/2019 15:06:17, INFO : Activate state: Idle
    31/01/2019 15:06:17, INFO : Obtaining SQL instances on local machine...
    31/01/2019 15:06:17, INFO : Computer is joined to domain: GEM
    31/01/2019 15:06:17, INFO : Found MSI: \Console64.msi version: 5.4.1
    31/01/2019 15:06:17, INFO : Found installed component: {6EF27BE8-9977-4682-A487-5F2B01AF5BFA} version: 5.4.0
    31/01/2019 15:06:17, INFO : Found MSI: \Server64.msi version: 5.4.1
    31/01/2019 15:06:17, INFO : Found installed component: {0E16412A-7A5C-4BAD-BAF8-9CCD7D8C9983} version: 5.4.1
    31/01/2019 15:06:17, INFO : Found MSI: \Database64.msi version: 5.4.1
    31/01/2019 15:06:17, INFO : Found installed component: {2C7A82DB-69BC-4198-AC26-BB862F1BE4D0} version: 1.5.8.11
    31/01/2019 15:06:17, INFO : Found MSI: SUM.msi version: 1.6.1.124
    31/01/2019 15:06:17, INFO : SEC Server detected.
    31/01/2019 15:06:17, INFO : SEC Database detected.
    31/01/2019 15:06:17, INFO : SUM detected.
    31/01/2019 15:06:17, INFO : Modify workflow
    31/01/2019 15:06:17, INFO : Changed installation value: INSTALLDIR="C:\Program Files\Sophos" 
    31/01/2019 15:06:17, INFO : Changed installation value: SERVER_FEEDBACKENABLED="1" 
    31/01/2019 15:06:17, INFO : Changed installation value: SERVER_PORT="80" 
    31/01/2019 15:06:17, INFO : Changed installation value: SERVER_USERNAME="SophosManagement" 
    31/01/2019 15:06:17, INFO : Changed installation value: SERVER_USERNAMEDOMAIN="GEM" 
    31/01/2019 15:06:17, INFO : Changed installation value: DATABASE_SERVERNAME="(local)\SOPHOS" DATABASE_CONNECTIONSTRING="" 
    31/01/2019 15:06:17, INFO : upn found: SophosManagement@gem.local
    31/01/2019 15:06:17, INFO : Changed installation value: SERVER_UPN="SophosManagement@gem.local" 
    31/01/2019 15:06:17, INFO : Changed installation value: SERVER_FEEDBACKENABLED="1" 
    31/01/2019 15:06:17, INFO : Changed installation value: 
    31/01/2019 15:06:17, INFO : Changed installation value: 
    31/01/2019 15:06:17, INFO : Checking for presence of database: SOPHOSENC52 on instance: (local)\SOPHOS...
    31/01/2019 15:06:17, INFO : Database: SOPHOSENC52 does not exist on instance: (local)\SOPHOS
    31/01/2019 15:06:17, INFO : Checking for presence of database: SOPHOSENC51 on instance: (local)\SOPHOS...
    31/01/2019 15:06:17, INFO : Database: SOPHOSENC51 does not exist on instance: (local)\SOPHOS
    31/01/2019 15:06:17, INFO : Changed installation value: ENCDBVERSION="0" 
    31/01/2019 15:06:17, INFO : Entered Welcome page.
    31/01/2019 15:06:18, INFO : Finished retrieving instances - Timeout
    31/01/2019 15:06:18, INFO : Obtaining remote SQL instances on network...
    31/01/2019 15:06:19, INFO : Finished retrieving instances - Timeout
    31/01/2019 15:06:22, INFO : Clicked Cancel button
    31/01/2019 15:06:23, INFO : Confirmed cancellation of the bootstrapper
    31/01/2019 15:06:23, INFO : Cancel state: Idle
    31/01/2019 15:06:23, INFO : Deactivate state: Idle
    31/01/2019 15:06:23, INFO : Activate state: Cancelled
    31/01/2019 15:06:23, INFO : Canceled wizard.
    31/01/2019 15:06:25, INFO : Finished Bootstrapper
    31/01/2019 15:06:25, INFO : Cleaned up socket.
    31/01/2019 15:06:25, INFO : Uninitialized COM in main thread
    

    thanks
    Mark

  • In reply to Mark Burchett:

    Hello Mark,

    looks like you've installed the database from the sec_541 directory and now it complains about different versions installed. It is not too hard to resolve, uninstall the just installed and reinstall from the sec_540 directory. BTW - it looks like the console component is also not installed.

    For the attempt that wasn't cancelled early there's
     : System Property Check: The logged on user must be able to connect to the domain controller in Active Directory - FAILED
    There's apparently some problem with this server and AD but I have no advice at the moment.

    Christian