"[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

Article Id: 7046
Status: Published
Updated On: 14-02-2018 08:14
Legacy Id: TEC1107535
Products:
SUPPORT AUTOMATION- SERVER , CA Service Desk Manager - Unified Self Service , KNOWLEDGE TOOLS , 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 -->

Cause:

The MDB database does not have an owner set

Environment:

CA Service Desk Manager 14.1 and laterAll Supported Operating Systems

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