Loading...

Knowledge Center


User 'XXXXXX' does not have permission to run DBCC FREEPROCCACHE (ePolicy Orchestrator 5.3.2 upgrade to 5.9 fails)
Technical Articles ID:   KB89218
Last Modified:  10/25/2017

Environment

McAfee ePolicy Orchestrator (ePO) 5.9, 5.3.2

Problem

A clean install or upgrade of ePO from version 5.3.2 to 5.9 fails with the following error:
 
User 'XXXXXX' does not have permission to run DBCC freeproccache.

The following is recorded in the MSI log:
 
EPO590CALog: epoST.err: C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOCore\5.9.0.732\install.xml:778: The following error occurred while executing this line:
EPO590CALog: epoST.err: C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOCore\5.9.0.732\install.xml:181: java.sql.SQLException: User 'XXXXXXX' does not have permission to run DBCC freeproccache.

Cause

A defect identified in the ePO 5.9.0 installation scripts resulted in the installation running FREEPROCCACHE, which requires system administrator-level permissions. This requirement was not an intentional design change for 5.9.0. It has been addressed in ePO 5.9.1.

Use the following workaround to temporarily grant system administrator-level permissions and allow the 5.9.0 installer to succeed.

Solution

This issue is resolved in ePO 5.9.1, which is available from the Product Downloads site at: http://mcafee.com/us/downloads/downloads.aspx

NOTE: You need a valid Grant Number for access. KB56057 provides additional information about the Product Downloads site and alternate locations for some products.

Updates are cumulative; Technical Support recommends that you install the latest one.

Workaround

Grant your database user account the system administrator (sysadmin) permission for the installation period:
  1. Open SQL Management Studio.
  2. Locate the account used to connect to SQL (core\config).
  3. Give the account Public, DB Creator, and Sysadmin permissions.
  4. Remove the sysadmin permission when the upgrade is complete.

Rate this document

Languages:

This article is available in the following languages:

English United States
Japanese

Beta Translate with

Select a desired language below to translate this page.

Glossary of Technical Terms


 Highlight Glossary Terms

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