Re: Setuser failed?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 30 Jan 2007 23:02:22 +0000 (UTC)
gurbao (audunj@xxxxxxxxx) writes:
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?
Both SETUSER and sp_makewebtask are deprecated, so in the long run, you
should probably look into to replace the code.
It wasn't clear to me: who is doing SETUSER on 'sa'? sp_makewebtask
or the procedure that calls it? If the latter, can you post the code?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Setuser failed?
- From: gurbao
- Setuser failed?
- Prev by Date: Re: Non-SA can't view Activity Monitor with VIEW SERVER STATE perm
- Next by Date: Re: Can't access linked server, except from
- Previous by thread: Setuser failed?
- Next by thread: problem using sql server
- Index(es):
Relevant Pages
|
|
