Loading...

Knowledge Center


Cannot execute as the database principal because the principal "dbo" does not exist (in eventparser.log and the ePolicy Orchestrator console fails to display point product events)
Technical Articles ID:   KB86071
Last Modified:  8/7/2018
Rated:


Environment

McAfee Endpoint Security 10.x
McAfee ePolicy Orchestrator (ePO) 5.x
McAfee SiteAdvisor Enterprise 3.5

Problem

Point product events do not appear in the ePO console, and the ePO event debug folder fills up with .xml files. In addition, the ePO eventparser.log displays the following error:
 
epoevents_dbinfo.cpp(163): COM Error 0x80040E14, source=Microsoft OLE DB Provider for SQL Server, desc=Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission., msg=IDispatch error #3092

Cause

The ePO database user is in a bad state, usually related to a database restore.

Solution

Perform the following steps to fix the ePO database user:
  1. Change the ePO database user to any other user on the Configure Database Settings page at https://<server_name>:8443/core/config.
  2. Restart the ePO services:
    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
       
  3. Run the following query to drop the original ePO database user from the ePO database:
    1. Open Microsoft SQL Server Management Studio.
    2. Type the username and password information for the account specified and click Connect.
    3. Expand Databases.
    4. Right-click the ePO database (where the default name is ePO_<ePO_server_name>) and select New Query.
    5. Paste the following SQL statement into the query window:
       
      USE [EPO_DB];
      DROP USER [EPO_DB_USER];

      where EPO_DB is the ePO database name and EPO_DB_USER is the original ePO database user.
    6. Click Execute.
  4. Run the following query to reset the original ePO database user:
     
    ALTER AUTHORIZATION
    ON DATABASE::[
    EPO_DB]
    TO [EPO_DB_USER];
     
    where EPO_DB is the ePO database name and EPO_DB_USER is the original ePO database user.
     
  5. Change the ePO database user to the original user on the Configure Database Settings page at https://<server_name>:8443/core/config.

Rate this document

Glossary of Technical Terms


 Highlight Glossary Terms

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