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 -->
The MDB database does not have an owner set
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
Was this information helpful?