"[Microsoft OLE DB Provider for SQL Server] [ SQL Code=15517 SQL State=42000] Cannot execute as the database principal because the principal "ServiceDesk" does not exist, this type of principal cannot be impersonated, or you do not have permission" error

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

The following error appears when running GRLoader command to load data to the CA Service Desk Manager (CA SDM) CMDB:

<!--ERROR: NO AHD04199:An unexpected error occurred. Contact your administrator. [Microsoft OLE DB Provider for SQL Server] [ SQL Code=15517 SQL State=42000] Cannot execute as the database principal because the principal "ServiceDesk" does not exist, this type of principal cannot be impersonated, or you do not have permission. @|domsrvr|rWdUCA|1495073852|1 -->

Environment

CA Service Desk Manager 14.1 and laterAll Supported Operating Systems

Cause

The MDB database does not have an owner set

Resolution

1. Log into SQL Server Management Studio as the 'SA' SQL Administrator account

2.  Expand DATABASES, locate the MDB database, right-click  and select PROPERTIES->FILES->ASSIGN "sa" as owner

3.  Save Changes

4.  Reattempt the GRLoader command

Additional Information

https://docops.ca.com/ca-service-management/14-1/en/reference/ca-service-desk-manager-reference-commands/cmdb-technical-reference/general-resource-loader-grloader/the-grloader-command