Loading...

Knowledge Center

Unable to log on to the ePolicy Orchestrator console after changing the password of the account used to connect to SQL
Technical Articles ID:   KB69850
Last Modified:  6/11/2019
Rated:

Environment

McAfee ePolicy Orchestrator (ePO) 5.x

Problem

You are unable to log on to the ePO console.

Problem

The ePO log on screen displays the following:

Log on to McAfee Foundation Services

When this error displays, the language cannot be selected.

Problem

The orion.log records the following error: 

ERROR: [com.mcafee.orion.core.db.base.Database]: Constructor threw exception; nested exception is java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. 
CommonEvents - Dependency ComputerMgmt had initialization error

System Change

The password of the account that is used to connect ePO to SQL has been changed.

Cause

The password was not changed in the ePO Database Settings page.

Solution

On the ePO Database Settings page, change the database account information:
  1. Log on to the ePO Database Settings page: https://localhost:8443/core/config-auth, where 8443 is the ePO console port.
  2. Type the password of the account you are using to connect to SQL in the User password field.
  3. Retype the password in the Confirm password field.
  4. Click Test Connection to verify the new password connection to the SQL database.
  5. Click Apply and close the Database Settings page.

Solution

If you cannot log on to the Database Settings page because you are using a remote console, do the following:
  1. Change the password of the account back to the previous one used to connect to SQL.
  2. Log on to the ePO Database Settings page: https://localhost:8443/core/config-auth, where 8443 is the ePO console port.
  3. Type the password of the account you are using to connect to SQL in the User password field.
  4. Retype this password in the Confirm password field.
  5. Click Test Connection to verify the new password connection to the SQL database.
  6. Click Apply and close the Database Settings page.

Solution

If you are unable to open the Database Settings page because of invalid credentials on the https://localhost:8443/core/config-auth page, do the following:

WARNING: These steps are not supported on Remote Agent Handler. If you need to change the database passwords in the db.properties file on Remote Agent Handler, follow the steps in KB75333. 

NOTE: Port 8443 is the ePO console port for the following steps.
  1. Back up the db.properties file, located by default in <ePO installation directory>\server\conf\orion\.
  2. Press Windows+R, type services.msc, and click OK.
  3. Right-click each of the following ePO services and click Stop:

    McAfee ePolicy Orchestrator x.x.x Application Server
    McAfee ePolicy Orchestrator x.x.x Event Parser
    McAfee ePolicy Orchestrator x.x.x Server
     
  4. Edit the original db.properties in Notepad.
  5. Remove any value after the equal sign (=) for the following entries:

    db.user.domain=
    db.user.passwd.encrypted=
     
  6. Save the db.properties file.
  7. Right-click the following ePO service and click Start:

    McAfee ePolicy Orchestrator x.x.x Application Server
     
Open the Database Settings page again and make the needed changes:
  1. Open https://localhost:8443/core/config again on the ePO server.
  2. In the User name field, type the name of the account you are using to connect to SQL.
  3. In the User domain field, type the domain name to which ePO is joined.

    NOTE: If you are using SQL authentication, leave this field blank.
     
  4. Type the password of the account you are using to connect to SQL in the User password field.
  5. Retype this password in the Confirm password field.
  6. Click Test Connection to verify the new password connection to the SQL database.
  7. Click Apply and close the Database Settings page.
  8. Press Windows+R, type services.msc and click OK.
  9. Right-click the following ePO service and click Restart: 

    McAfee ePolicy Orchestrator x.x.x Application Server
     
  10. Right-click each of the following ePO services and click Start:

    McAfee ePolicy Orchestrator x.x.x Event Parser
    McAfee ePolicy Orchestrator x.x.x Server

Rate this document

Glossary of Technical Terms


 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.