Hello.
I have a problem with SQL Server 2005 SP2:
An exception occurred while enqueueing 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.
Can you help me about this problem?
Thank you.Jan,
If this database was restored from another server, the login that is the
database owner (and therefore the login that becomes dbo) does not exist on
the new server. If that is it, try changing the database owner by running:
ALTER AUTHORIZATION ON DATABASE <dbname> TO <loginname>
Even if the owner is a login (other that 'sa') with the same name on both
machines, if the SID is different they do not actually match up, no matter
what the SSMS makes it look like.
RLF
"Jan" <jankenter@.hotmail.com> wrote in message
news:6337D283-F24A-47B5-8FC6-D99C013E6BCD@.microsoft.com...
> Hello.
> I have a problem with SQL Server 2005 SP2:
> An exception occurred while enqueueing 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.
> Can you help me about this problem?
> Thank you.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment