Setuser failed?
- From: "gurbao" <audunj@xxxxxxxxx>
- Date: 30 Jan 2007 01:07:04 -0800
Hi,
I have recently migrated from sql server 2000 to 2005.
One of my old jobs is currenty failing with
Msg 15157, Sev 11, State 1: Setuser failed because of one of the
following reasons: the database principal 'sa' does not exist, its
corresponding server principal does not have server access, this type
of database principal cannot be impersonated, or you do not have
permission. [SQLSTATE 42000]
The jobs calls a procedure that again uses sp_makewebtask. It is this
proc that throws the above error.
Someone with a clue on what I should do to resolve this?
Regards,
.
- Follow-Ups:
- Re: Setuser failed?
- From: Erland Sommarskog
- Re: Setuser failed?
- Prev by Date: Re: SQL Accounts on Mirror
- Next by Date: problem using sql server
- Previous by thread: Re: Non-SA can't view Activity Monitor with VIEW SERVER STATE perm.
- Next by thread: Re: Setuser failed?
- Index(es):
Relevant Pages
|