Upgrade from ePolicy Orchestrator 5.9.x fails (SQL permissions)

Technical Articles ID: KB94975
Last Modified: 10/12/2021

Environment

McAfee ePolicy Orchestrator (ePO) 5.10.x

Problem

An upgrade from ePO 5.9.x to 5.10 fails. The upgrade rolls back.

The errors below are recorded in the EPO5100-Install-MSI.log file:

20:14:14 EPO5100CALog: FAILURE: In LaunchApplication while trying to run the following program:
"C:\Users\*********\AppData\Local\Temp\McAfeeLogs\EPO5100-Troubleshoot\OutputFiles\epoST.bat"
1: 20:14:14 EPO5100CALog: epoST.err: Error encountered while running command:ext.install extension=file:///C:/PROGRA~2/McAfee/EPOLIC~1/INSTAL~1/ePO/EXTENS~2/epoST.zip
1: 20:14:14 EPO5100CALog: epoST.err:
1: 20:14:14 EPO5100CALog: epoST.err: java.io.IOException: Error 0 :
1: 20:14:14 EPO5100CALog: epoST.err: The following error occurred while executing this line:
1: 20:14:14 EPO5100CALog: epoST.err: C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOCore\5.10.0.2428\install.xml:666: The following error occurred while executing this line:
1: 20:14:14 EPO5100CALog: epoST.err: C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOCore\5.10.0.2428\install.xml:214: java.sql.SQLException: CREATE DATABASE permission denied in database 'master'.

Cause

The SQL account doesn’t have the required permissions.

Solution

The account that you use to apply an upgrade to ePO must have the following server roles:

Public
db_owner
db_creator

NOTES:

After the database is installed, you can remove the dbcreator role from the ePO SQL user.
The upgrade to ePO 5.10.x requires db_creator permissions. The permissions are required because a new database (epo_Events) is created in the upgrade.

Affected Products

Configuration
ePolicy Orchestrator 5.10.x
Known Issue/Product Defect
Upgrade/Migrate

Languages:

This article is available in the following languages:

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

Knowledge Center

Upgrade from ePolicy Orchestrator 5.9.x fails (SQL permissions)

Environment

Problem

Cause

Solution

Affected Products

Languages:

Title

Title

Knowledge Center

Upgrade from ePolicy Orchestrator 5.9.x fails (SQL permissions)

Environment

Problem

Cause

Solution

Affected Products

Languages:

Choose your region

Title

Title