An exception occurred while enqueuing a message in the target queue. Error: 15517, State: 1. 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

Version 1

    Details

    The following error is shown frequently in the windows event logs

    An exception occurred while enqueuing a  message in the target queue. Error: 15517, State: 1. 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.

    GoldMine is also running slow for all users.


    Resolution

    [CAUSE]

    This error is related to an orphaned database owner on your database. This can be verified by either looking at object explorer details and identifying the database(s) without an entry in the Owner column or running a select against sys.databases to see the database owner that is no longer valid.

    [RESOLUTION]

    To work around this problem, change the database owner to a     valid login or domain user. To do this, run the following SQL  directly in SQL Management studio.statements:

    USE <DatabaseName> GO sp_changedbowner '<NewLogin>'
    Note: <DatabaseName> represents the     name of the database. <NewLogin> represents the name of the login that you wish to set.


    Additional Note:
    Please keep in mind that this information is provided as-is without warranty of any kind, GoldMine Technical Support does not assist in applying the provided resolution and it might be necessary to discuss prior with your IT or SQL DBA.