The license for ePolicy Orchestrator is invalid (SQL database connection fails)

Technical Articles ID: KB66166
Last Modified: 2022-05-27 19:03:42 Etc/GMT

Environment

ePolicy Orchestrator (ePO) 5.x

Problem

The following error displays when you try to log on to the ePolicy Orchestrator (ePO) console:

The license for ePolicy Orchestrator is invalid

Failed to load license data. To enter a new license, go here

Cause

ePO has to get the license key from the SQL database at logon. If ePO can't connect to the database currently, it fails with the invalid license message.

When an incorrect port is specified for the Database Server Port, the connection is still tests successful. But could cause an issue when ePO tries to get the license from the database.

NOTE: The Database Server Port is found within the core/config page.

Workaround 1

If the SQL Server is installed on the same server as ePO, verify the db.server.name entry is listed correctly in the db.properties file and change it, if needed:

Click Start, Run, type explorer, and click OK.
Right-click My Computer, Properties.
Click the Computer Name tab and note the server name.
Navigate to the following location (default specified):

c:\Program Files\McAfee\ePolicy Orchestrator\Server\conf\orion\db.properties
Right-click db.properties and click Open. Open this file with Notepad.
Compare the value of db.server.name= to the computer name obtained in Step 3.
Modify the value if the SQL Server is installed on the same server as ePO. If the entry does not match.

NOTE: If the SQL Server is on a different server, this value identifies the server name as that SQL Server.
Verify that the account listed in the db.user.name field is not locked out. If so, reset the account on the server and skip to Step 14.
Click File, Save.
Click File, Exit.
Click Start, Run, type services.msc, and click OK.
Right-click each of the services below and select Restart:
- McAfee ePolicy Orchestrator x.x.x Server
- McAfee ePolicy Orchestrator x.x.x Event Parser
- McAfee ePolicy Orchestrator x.x.x Application Server
Close the Services window.
Attempt to log on to the ePO console again.

Workaround 2

Identify the port on which SQL is listening:

Open SQL Configuration Manager from the SQL Server and connect to the database instance to which ePO is pointing.
Expand SQL Server Network Configuration and select Protocols for 'x' (where 'x' is the name of the instance).
Double-click TCP/IP on the right side and select the IP addresses tab.
Scroll to the bottom. The TCP Port is listed under the IPAll section.

Change the database Server Port to the correct port (if needed):

Click Start, Run, type explorer, and click OK.
Navigate to the following location (default specified):

c:\Program Files\McAfee\ePolicy Orchestrator\Server\conf\orion\db.properties
Right-click db.properties and click Open. Open this file with Notepad.
Compare the value of db.port= to the port number obtained in the Check the port SQL is listening on section above.
Modify this value if the port entry does not match.
Click File, Save.
Click File, Exit.
Click Start, Run, type services.msc, and click OK.
Right-click each of the services below and select Restart:
- McAfee ePolicy Orchestrator x.x.x Server
- McAfee ePolicy Orchestrator x.x.x Event Parser
- McAfee ePolicy Orchestrator x.x.x Application Server
Close the Services window.
Attempt to log on to the ePO console again.

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

The license for ePolicy Orchestrator is invalid (SQL database connection fails)

Environment

Problem

Cause

Workaround 1

Workaround 2

Affected Products

Languages:

Title

Title

Knowledge Center

The license for ePolicy Orchestrator is invalid (SQL database connection fails)

Environment

Problem

Cause

Workaround 1

Workaround 2

Affected Products

Languages:

Choose your region

Title

Title