Re: Event ID 28005; Error 15517
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Mon, 17 Dec 2007 14:22:35 -0500
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@xxxxxxxxxxx> wrote in message
news:6337D283-F24A-47B5-8FC6-D99C013E6BCD@xxxxxxxxxxxxxxxx
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.
.
- References:
- Event ID 28005; Error 15517
- From: Jan
- Event ID 28005; Error 15517
- Prev by Date: Event ID 28005; Error 15517
- Next by Date: Re: General permission question
- Previous by thread: Event ID 28005; Error 15517
- Next by thread: Re: General permission question
- Index(es):
Relevant Pages
|
|
