How to set SQL authentication account information

Technical Articles ID: KB51465
Last Modified: 8/12/2021

Environment

McAfee ePolicy Orchestrator (ePO) 5.x

Microsoft SQL Servers - all supported versions

For details of ePO and SQL supported environments, see KB51569 - Supported platforms for ePolicy Orchestrator.

Problem

The process CfgNaiMs.exe is no longer available in ePO. ePO now uses a web-based interface to configure database connectivity settings. Incorrect configurations can cause database connections to fail with either of the following errors in the orion.log (<epo installation directory>\server\logs\orion.log):

Detected a possible mismatch between the server and database.

Failed to establish a database connection java.sql.SQLException: Network error IOException: Connection refused: connect

Solution

To open the Database Configuration page for ePO using a web connection:

Open Internet Explorer.
Open the Configure Database Settings page. Go to https://<servername>:8443/core/config

NOTE: If you don’t use the default port (8443), substitute the console logon port you configured. You can use a specific server name in the previous example only if you can resolve that name in your environment.
Under Configure Database Settings, modify the following entries as needed:
- Database server
- Server instance
- Database name
- Authentication type
- User name
- User password

NOTE: If you change any of the above entries, make sure that you click Test Connection. The test verifies that the connection to the database is successful with the new settings before continuing.

Click Apply.
Restart the ePolicy Orchestrator Application Server service:
1. Press Windows+R, type services.msc, and click OK.
2. Right-click the following services and select Restart:
  
  McAfee ePolicy Orchestrator x.x.x Application Server
  McAfee ePolicy Orchestrator x.x.x Server
  McAfee ePolicy Orchestrator x.x.x Event Parser
Verify the ePO console loads.

Solution

To change the config-auth page, perform the steps below using either of the following account options:

A SQL account
A trusted NT account

Option 1 - Use a SQL account:

Use the steps from Solution 1 to access the Database Configuration page.
Select the option use the SQL SA account.
Change User name field to SA.
Type your password in the Password field.

Option 2 - A trusted NT account:

Use the steps from Solution 1 to access the Database Configuration page.
Complete the following fields:

User name
User domain
User password
Confirm password
Click Test connection.
When validated, click Apply, and then close the Configuration page.

Restart ePO services and then log on to the ePO console:

Click Start, Run, type services.msc, and click OK.
Right-click each of the following ePO services and click Stop:

McAfee ePolicy Orchestrator Server
McAfee ePolicy Orchestrator Event Parser
McAfee ePolicy Orchestrator Application Server
Close the Services window.
Log on to the ePO console.

NOTE: Renaming the Orion.log (<ePO installation directory>\Server\Logs\orion.log) before you start services generates a new log at service start. This action is helpful for validating that the issue is resolved.

Previous Document ID ^(Secured)

613911

Affected Products

ePolicy Orchestrator 5.9
ePolicy Orchestrator 5.10.x

Languages:

This article is available in the following languages:

English United States
Spanish Spain
French
Italian
Japanese
Portuguese Brasileiro
Chinese Simplified

Glossary of Technical Terms

Highlight Glossary Terms

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

Knowledge Center

How to set SQL authentication account information

Environment

Problem

Solution

Solution

Previous Document ID ^(Secured)

Affected Products

Languages:

Glossary of Technical Terms

Title

Title

Knowledge Center

How to set SQL authentication account information

Environment

Problem

Solution

Solution

Previous Document ID (Secured)

Affected Products

Languages:

Glossary of Technical Terms

Choose your region

Title

Title

Previous Document ID ^(Secured)