Loading...

Knowledge Center

How to change to SQL credentials for connecting ePolicy Orchestrator to the database
Technical Articles ID:   KB70722
Last Modified:  9/11/2019
Rated:

Environment

McAfee ePolicy Orchestrator (ePO) 5.x

Problem

The Agent Handler can't connect to the database because it can't use domain credentials when:
  • The ePO server is in a domain
    And
  • An Agent Handler is installed in the DMZ

Solution

Configure the Agent Handler to use the SQL sa account.

Enable the sa account or create a SQL account
  1. Open SQL Management Studio.
  2. Expand Security, Logins, and double-click the sa account.
  3. Type and confirm a password in the General tab under the logon name section.
  4. Set Login to Enabled in the Status tab and click OK.
  5. Right-click the database instance name and click Properties.
  6. To enable the sa account, select SQL Server and Windows Authentication mode in the Security tab.
  7. Restart the SQL Server service.
Change the account to use for connecting to the database
  1. Open a web browser and go to https://localhost:8443/core/config-auth
    (where 8443 is the port for the console communication).
  2. Log on with ePO credentials.
  3. Delete the entry in the User Domain field.
  4. Type sa in the User name field.
  5. Type the password for the sa account into the User password and Confirm password fields.
  6. Click Test Connection.
  7. Only click Apply, if the test is successful.

Rate this document

Glossary of Technical Terms


 Highlight Glossary Terms

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