Principal "dbo" does not exist (console doesn't display managed product events)

Technical Articles ID: KB86071
Last Modified: 2023-02-06 21:59:12 Etc/GMT

Environment

Endpoint Security 10.x
ePolicy Orchestrator (ePO) 5.x

Problem

Managed product events do not appear in the ePO console. The ePO event debug folder fills up with .xml files. 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, which is often related to a database restore.

Solution

To fix the ePO database user, perform the following steps:

Change the ePO database user to any other user on the Configure Database Settings page at https://<server_name>:8443/core/config.
Restart the ePO services:
1. Press Windows+R, type services.msc, and click OK.
2. Right-click the following services and select Restart:
  
  ePolicy Orchestrator x.x.x Application Server
  ePolicy Orchestrator x.x.x Server
  ePolicy Orchestrator x.x.x Event Parser
Drop the original ePO database user from the ePO database. Run the following query:
1. Open Microsoft SQL Server Management Studio.
2. Type the user name 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.
Reset the original ePO database user. Run the following query:

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.
Change the ePO database user to the original user on the Configure Database Settings page at https://<server_name>:8443/core/config.

Related Information

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

Principal "dbo" does not exist (console doesn't display managed product events)

Environment

Problem

Cause

Solution

Related Information

Affected Products

Languages:

Title

Title

Knowledge Center

Principal "dbo" does not exist (console doesn't display managed product events)

Environment

Problem

Cause

Solution

Related Information

Affected Products

Languages:

Choose your region

Title

Title