Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 6 replies
  • Subscribers 2 subscribers
  • Views 7265 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Upgrade from SEC 5.0.0 to 5.5.0 fails on DB credentials

ThorWithAnE

After EULA, I enter DB credentials of domain account and get "The user credentials cannot connect to the specified SQL Server instance".  Any credentials fail.  Verified thru sqlcmd access to DB.

From the log bootstrapper all checks Passed and connections to DB for Initial Catalog='SOPHOS50' checks succeeded, but it looks like it fails when it tries to connect to an initial catalog that does not exist yet:

6/4/2018 10:04:19 AM, INFO : Log on succeeded with the credentials XXX\sophosmanagement
6/4/2018 10:04:19 AM, INFO : Validating password...
6/4/2018 10:04:19 AM, INFO : log on succeeded with the credentials XXX\sophosmanagement
6/4/2018 10:04:19 AM, INFO : Validating whether credentials provided can access the selected sql instance...
6/4/2018 10:04:19 AM, ERROR : COM error. Connection string: Provider='sqloledb'; Data Source='(local)\SOPHOS'; Initial Catalog='SOPHOS550'; Integrated Security='SSPI'; - Error: Unspecified error, Description: Cannot open database "SOPHOS550" requested by the login. The login failed.
6/4/2018 10:04:19 AM, ERROR : Credentials could not connect to the remote database

 

HKLM\SOFTWARE\Wow6432Node\Sophos\EE\Management Tools\DatabaseUser\   lists a disabled domain admin. 



This thread was automatically locked due to age.
Parents
  • 0

    Hello Thore Clausen,

    please post the complete bootstrapper log. when it tries to connect to an initial catalog that does not exist yet is not the expected sequence. The bootstrapper should detect that an upgrade of the database component is required and call the database installer. This is a local database?
    Did you run the bootstrapper more than once?

    Christian

Reply
  • 0

    Hello Thore Clausen,

    please post the complete bootstrapper log. when it tries to connect to an initial catalog that does not exist yet is not the expected sequence. The bootstrapper should detect that an upgrade of the database component is required and call the database installer. This is a local database?
    Did you run the bootstrapper more than once?

    Christian

Children
  • 0 in reply to QC

    Started Setup.exe, located at: C:\sec_550\ServerInstaller
    6/4/2018 10:56:22 AM, INFO : Verifying files in folder
    6/4/2018 10:56:22 AM, INFO : Target folder verification completed successfully
    6/4/2018 10:56:22 AM, INFO : Initialized COM in the main thread
    6/4/2018 10:56:22 AM, INFO : The Winsock 2.2 dll was found okay.
    6/4/2018 10:56:22 AM, INFO : --------System Information------------
    6/4/2018 10:56:22 AM, INFO : Computer Name: sophos
    6/4/2018 10:56:22 AM, INFO : Operating System: 6.1.0
    6/4/2018 10:56:22 AM, INFO : Service Pack: 1
    6/4/2018 10:56:22 AM, INFO : System Type: 64 bit Operating System
    6/4/2018 10:56:22 AM, INFO : Locale: en
    6/4/2018 10:56:22 AM, INFO : Logged-on User: XXX\thore
    6/4/2018 10:56:22 AM, INFO : Domain: XXX
    6/4/2018 10:56:22 AM, INFO : --------------------------------------
    6/4/2018 10:56:22 AM, INFO : Detected MSI version: 5.0.7601
    6/4/2018 10:56:22 AM, INFO : Activate state: Idle
    6/4/2018 10:56:22 AM, INFO : Obtaining SQL instances on local machine...
    6/4/2018 10:56:22 AM, INFO : Computer is joined to domain: XXX
    6/4/2018 10:56:22 AM, INFO : Found installed component: {5F3E2B99-3883-46FD-9B02-31B7C480A8B7} version: 5.0.0
    6/4/2018 10:56:22 AM, INFO : Found MSI: \Console64.msi version: 5.5.0
    6/4/2018 10:56:22 AM, INFO : Found installed component: {3886EB02-D881-4603-953B-4AE0E2A39665} version: 5.0.0
    6/4/2018 10:56:22 AM, INFO : Found MSI: \Server64.msi version: 5.5.0
    6/4/2018 10:56:22 AM, INFO : Found MSI: \Database64.msi version: 5.5.0
    6/4/2018 10:56:22 AM, INFO : Found installed component: {2C7A82DB-69BC-4198-AC26-BB862F1BE4D0} version: 1.6.2.186
    6/4/2018 10:56:22 AM, INFO : Found MSI: SUM.msi version: 1.6.1.124
    6/4/2018 10:56:22 AM, INFO : SEC Console detected.
    6/4/2018 10:56:22 AM, INFO : SEC Server detected.
    6/4/2018 10:56:22 AM, INFO : SUM detected.
    6/4/2018 10:56:22 AM, INFO : Upgrade 5.x workflow
    6/4/2018 10:56:22 AM, INFO : Changed installation value: INSTALLDIR="C:\Program Files\Sophos" INSTALLDIR32="C:\Program Files (x86)\Sophos" SUM_INSTALLDIR="C:\Program Files (x86)\Sophos\Update Manager"
    6/4/2018 10:56:22 AM, INFO : Changed installation value: UPGRADE="1"
    6/4/2018 10:56:22 AM, INFO : Changed installation value: SERVER_COMPUTERNAME="sophos"
    6/4/2018 10:56:22 AM, INFO : Changed installation value: SERVER_PORT="80"
    6/4/2018 10:56:22 AM, INFO : Changed installation value:
    6/4/2018 10:56:22 AM, INFO : Changed installation value:
    6/4/2018 10:56:22 AM, ERROR : Could not deobfuscate password
    6/4/2018 10:56:22 AM, INFO : Changed installation value:
    6/4/2018 10:56:22 AM, INFO : upn found: <old domain admin>
    6/4/2018 10:56:22 AM, INFO : Changed installation value: SERVER_UPN="<old domain admin>"
    6/4/2018 10:56:22 AM, INFO : Could not get database account information from previous version. Database Page will be displayed
    6/4/2018 10:56:22 AM, INFO : Changed installation value: DATABASE_SERVERNAME="(local)\SOPHOS" DATABASE_CONNECTIONSTRING=""
    6/4/2018 10:56:22 AM, INFO : Changed installation value: SERVER_FEEDBACKENABLED="1"
    6/4/2018 10:56:22 AM, INFO : Changed installation value:
    6/4/2018 10:56:22 AM, INFO : Changed installation value:
    6/4/2018 10:56:22 AM, INFO : Changed installation value: DB_UPGRADE_VERSION="500"
    6/4/2018 10:56:22 AM, INFO : Checking for presence of database: SOPHOSENC52 on instance: ...
    6/4/2018 10:56:23 AM, INFO : Finished retrieving instances - Timeout
    6/4/2018 10:56:23 AM, INFO : Obtaining remote SQL instances on network...
    6/4/2018 10:56:24 AM, INFO : Finished retrieving instances - Timeout
    6/4/2018 10:56:40 AM, 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.
    6/4/2018 10:56:40 AM, INFO : Checking for presence of database: SOPHOSENC51 on instance: ...
    6/4/2018 10:56:58 AM, 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.
    6/4/2018 10:56:58 AM, INFO : Changed installation value: ENCDBVERSION="0"
    6/4/2018 10:56:58 AM, INFO : Entered Welcome page.
    6/4/2018 10:58:22 AM, INFO : Running System Property Check: User must be an administrator on this computer...
    6/4/2018 10:58:22 AM, INFO : System Property Check: User must be an administrator on this computer - PASSED
    6/4/2018 10:58:22 AM, INFO : Running System Property Check: All SEC components installed must be the same version...
    6/4/2018 10:58:22 AM, INFO : Found installed component: {5F3E2B99-3883-46FD-9B02-31B7C480A8B7} version: 5.0.0
    6/4/2018 10:58:22 AM, INFO : Found MSI: \Console64.msi version: 5.5.0
    6/4/2018 10:58:22 AM, INFO : Found installed component: {3886EB02-D881-4603-953B-4AE0E2A39665} version: 5.0.0
    6/4/2018 10:58:22 AM, INFO : Found MSI: \Server64.msi version: 5.5.0
    6/4/2018 10:58:22 AM, INFO : Found MSI: \Database64.msi version: 5.5.0
    6/4/2018 10:58:22 AM, INFO : Found installed component: {2C7A82DB-69BC-4198-AC26-BB862F1BE4D0} version: 1.6.2.186
    6/4/2018 10:58:22 AM, INFO : Found MSI: SUM.msi version: 1.6.1.124
    6/4/2018 10:58:22 AM, INFO : System Property Check: All SEC components installed must be the same version - PASSED
    6/4/2018 10:58:22 AM, INFO : Entered Eula page.
    6/4/2018 10:58:23 AM, INFO : Accepted Eula.
    6/4/2018 10:58:23 AM, INFO : Running System Property Check: Support operating system version and service pack must be installed...
    6/4/2018 10:58:23 AM, INFO : Version: 6.1.0 SP: 1 Architecture: 2 Edition: 7
    6/4/2018 10:58:23 AM, INFO : OS version 6.1 Service pack installed
    6/4/2018 10:58:23 AM, INFO : System Property Check: Support operating system version and service pack must be installed - PASSED
    6/4/2018 10:58:23 AM, INFO : Running System Property Check: Encryption must be not installed...
    6/4/2018 10:58:23 AM, INFO : System Property Check: Encryption must be not installed - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: System account must be able to impersonate other accounts...
    6/4/2018 10:58:24 AM, INFO : System Property Check: System account must be able to impersonate other accounts - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Machine name should not exceed 15 characters...
    6/4/2018 10:58:24 AM, INFO : System Property Check: Machine name should not exceed 15 characters - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Computer should have only one network adapter to ensure that RMS binds correctly...
    6/4/2018 10:58:24 AM, INFO : System Property Check: Computer should have only one network adapter to ensure that RMS binds correctly - PASSED
    6/4/2018 10:58:24 AM, 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)...
    6/4/2018 10:58:24 AM, INFO : 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) - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Computer should have more than 4GB RAM...
    6/4/2018 10:58:24 AM, INFO : System Property Check: Computer should have more than 4GB RAM - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Operating system should support more than 5000 clients...
    6/4/2018 10:58:24 AM, INFO : System Property Check: Operating system should support more than 5000 clients - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: SEC 1.x, 2.0 or 3.x must not be installed on this computer...
    6/4/2018 10:58:24 AM, INFO : Product is not installed on local system. Upgrade code: {AC0DE50E-751A-4081-8F5B-8DC7ACBBBD4A}
    6/4/2018 10:58:24 AM, INFO : SEC 2.x is not installed on local system. MsiQueryProductState return -1
    6/4/2018 10:58:24 AM, INFO : SEC 3.x is not installed on local system. MsiQueryProductState return -1
    6/4/2018 10:58:24 AM, INFO : System Property Check: SEC 1.x, 2.0 or 3.x must not be installed on this computer - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Sophos Help Desk must not be installed on this computer...
    6/4/2018 10:58:24 AM, INFO : Product is not installed on local system. Upgrade code: {4ED6795A-1166-4277-B059-5189544286FE}
    6/4/2018 10:58:24 AM, INFO : System Property Check: Sophos Help Desk must not be installed on this computer - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Sophos Control Center 2.x must not be installed on this computer...
    6/4/2018 10:58:24 AM, INFO : Product is not installed on local system. Upgrade code: {99D634CF-54AF-4FCD-8259-AF8BAA7E7FC5}
    6/4/2018 10:58:24 AM, INFO : System Property Check: Sophos Control Center 2.x must not be installed on this computer - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Simple file sharing must be disabled...
    6/4/2018 10:58:24 AM, INFO : System Property Check: Simple file sharing must be disabled - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Sophos EM Console must not be installed on this computer...
    6/4/2018 10:58:24 AM, INFO : Product is not installed on local system. Upgrade code: {32FF7557-4C84-4E2E-B917-EE09D8E59FDE}
    6/4/2018 10:58:24 AM, INFO : System Property Check: Sophos EM Console must not be installed on this computer - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Sophos EM Library must not be installed on this computer...
    6/4/2018 10:58:24 AM, INFO : Product is not installed on local system. Upgrade code: {7A81AAEB-E07D-4E38-A36B-9B91FA0BA578}
    6/4/2018 10:58:24 AM, INFO : System Property Check: Sophos EM Library must not be installed on this computer - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Sophos Enterprise Console must not be running...
    6/4/2018 10:58:24 AM, INFO : EnterpriseConsole.exe not found in the list of processes running
    6/4/2018 10:58:24 AM, INFO : System Property Check: Sophos Enterprise Console must not be running - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Sophos Enterprise Manager must not be running...
    6/4/2018 10:58:24 AM, INFO : EnterpriseManager.exe not found in the list of processes running
    6/4/2018 10:58:24 AM, INFO : System Property Check: Sophos Enterprise Manager must not be running - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Sophos Control Center must not be running...
    6/4/2018 10:58:24 AM, INFO : SbeConsole.exe not found in the list of processes running
    6/4/2018 10:58:24 AM, INFO : System Property Check: Sophos Control Center must not be running - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: This computer should have at least 5GB free disk space on the primary drive...
    6/4/2018 10:58:24 AM, INFO : Enough space: 34923.000000 Mb
    6/4/2018 10:58:24 AM, INFO : System Property Check: This computer should have at least 5GB free disk space on the primary drive - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: SEC should not be installed on a Domain Controller...
    6/4/2018 10:58:24 AM, INFO : The computer is not a Domain Controller
    6/4/2018 10:58:24 AM, INFO : System Property Check: SEC should not be installed on a Domain Controller - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Logged on user must have rights to query the accounts used by the existing installation...
    6/4/2018 10:58:24 AM, INFO : System Property Check: Logged on user must have rights to query the accounts used by the existing installation - UNKNOWN
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: .NET 3.5 SP1 must be installed and the computer restarted before installing on Windows 2008 SP1...
    6/4/2018 10:58:24 AM, INFO : System Property Check: .NET 3.5 SP1 must be installed and the computer restarted before installing on Windows 2008 SP1 - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: The logged on user must be able to connect to the domain controller in Active Directory...
    6/4/2018 10:58:24 AM, INFO : System Property Check: The logged on user must be able to connect to the domain controller in Active Directory - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: All subscriptions must be either recommended or previous tags...
    6/4/2018 10:58:24 AM, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS50;Data Source=(local)\SOPHOS;
    6/4/2018 10:58:24 AM, INFO : Executing query...
    6/4/2018 10:58:24 AM, INFO : System Property Check: All subscriptions must be either recommended or previous tags - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: SUM subscription must be set to 'Recommended'...
    6/4/2018 10:58:24 AM, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS50;Data Source=(local)\SOPHOS;
    6/4/2018 10:58:24 AM, INFO : Executing query...
    6/4/2018 10:58:24 AM, INFO : System Property Check: SUM subscription must be set to 'Recommended' - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: All subscriptions should have autosubscribe enabled...
    6/4/2018 10:58:24 AM, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS50;Data Source=(local)\SOPHOS;
    6/4/2018 10:58:24 AM, INFO : Executing query...
    6/4/2018 10:58:24 AM, INFO : System Property Check: All subscriptions should have autosubscribe enabled - PASSED
    6/4/2018 10:58:24 AM, INFO : Running System Property Check: Endpoints with old RMS cannot handle SHA2 therefore they will not be able to communicate with management console...
    6/4/2018 10:58:24 AM, INFO : Checking MAC endpoints...
    6/4/2018 10:58:24 AM, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS50;Data Source=(local)\SOPHOS;
    6/4/2018 10:58:24 AM, INFO : Executing query...
    6/4/2018 10:58:24 AM, INFO : Checking UNIX endpoints...
    6/4/2018 10:58:24 AM, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS50;Data Source=(local)\SOPHOS;
    6/4/2018 10:58:24 AM, INFO : Executing query...
    6/4/2018 10:58:24 AM, INFO : Checking VSHIELD endpoints...
    6/4/2018 10:58:24 AM, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS50;Data Source=(local)\SOPHOS;
    6/4/2018 10:58:24 AM, INFO : Executing query...
    6/4/2018 10:58:24 AM, INFO : Checking LINUX endpoints...
    6/4/2018 10:58:24 AM, INFO : Connecting to existing Sophos database: Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS50;Data Source=(local)\SOPHOS;
    6/4/2018 10:58:24 AM, INFO : Executing query...
    6/4/2018 10:58:24 AM, INFO : System Property Check: Endpoints with old RMS cannot handle SHA2 therefore they will not be able to communicate with management console - PASSED
    6/4/2018 10:58:24 AM, INFO : Entered Database page.
    6/4/2018 10:58:28 AM, INFO : Checking whether account: XXX\thore is local...
    6/4/2018 10:58:28 AM, INFO : It is a domain account
    6/4/2018 10:58:35 AM, INFO : Validating account retrived by Object picker...
    6/4/2018 10:58:35 AM, INFO : Validating the user account...
    6/4/2018 10:58:35 AM, INFO : The specified account is not disabled and has a password that never expires.
    6/4/2018 10:58:36 AM, INFO : Validating password...
    6/4/2018 10:58:37 AM, ERROR : Failed to log on with the credentials XXX\SophosManagement - 1326 - Logon failure: unknown user name or bad password.

    6/4/2018 10:58:47 AM, INFO : Validating password...
    6/4/2018 10:58:47 AM, INFO : Log on succeeded with the credentials XXX\SophosManagement
    6/4/2018 10:58:47 AM, INFO : Validating password...
    6/4/2018 10:58:47 AM, INFO : log on succeeded with the credentials XXX\SophosManagement
    6/4/2018 10:58:47 AM, INFO : Validating whether credentials provided can access the selected sql instance...
    6/4/2018 10:58:48 AM, ERROR : COM error. Connection string: Provider='sqloledb'; Data Source='(local)\SOPHOS'; Initial Catalog='SOPHOS550'; Integrated Security='SSPI'; - Error: Unspecified error, Description: Cannot open database "SOPHOS550" requested by the login. The login failed.
    6/4/2018 10:58:48 AM, ERROR : Credentials could not connect to the remote database
    6/4/2018 11:06:42 AM, INFO : Clicked Cancel button
    6/4/2018 11:06:48 AM, INFO : Confirmed cancellation of the bootstrapper
    6/4/2018 11:06:48 AM, INFO : Cancel state: Idle
    6/4/2018 11:06:48 AM, INFO : Deactivate state: Idle
    6/4/2018 11:06:48 AM, INFO : Activate state: Cancelled
    6/4/2018 11:06:48 AM, INFO : Changed installation value: SERVER_USERNAMEDOMAIN="XXX"
    6/4/2018 11:06:48 AM, INFO : Changed installation value: SERVER_USERNAME="SophosManagement"
    6/4/2018 11:06:48 AM, INFO : Changed installation value: SERVER_UPN="SophosManagement@XXX.com"
    6/4/2018 11:06:48 AM, INFO : Changed installation value: SERVER_USERNAMEPASSWORD="********"
    6/4/2018 11:06:48 AM, INFO : Changed installation value: DATABASE_SERVERNAME="(local)\SOPHOS" DATABASE_CONNECTIONSTRING="Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS550;Data Source=(local)\SOPHOS;"
    6/4/2018 11:06:48 AM, INFO : Canceled wizard.
    6/4/2018 11:06:50 AM, INFO : Finished Bootstrapper
    6/4/2018 11:06:50 AM, INFO : Cleaned up socket.
    6/4/2018 11:06:50 AM, INFO : Uninitialized COM in main thread

Unfiltered HTML