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

Document ID:  TEC1107535
Last Modified Date:  06/16/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Service Desk Manager

Releases

  • CA Service Desk Manager:Release:14.1

Components

  • Svc Desk Integration:SDINTE
Issue:

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 later All 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:

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing