Re: Execute permission denied on object xp_SQLagent_notify
- From: Gabriela Nanau <GabrielaNanau@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 26 Feb 2007 07:19:28 -0800
Thanks a lot. The different ownership was indeed, the problem! I didn't even
think to check the owners for these 2 databases! It seemed so obvious that it
must be sa! That was a rookie's error, I'm sort of embarrassed! Now that I
think about, the msdb was brought from a different machine at some point and
it was probably then when the owner changed.
Once again thanks!
--
Gabriela Nanau
MCDBA
"Dan Guzman" wrote:
To add to Erland's response, you can fix msdb ownership can database options.
using the script below.
USE msdb
EXEC sp_changedbowner 'sa'
EXEC sp_dboption 'msdb', 'db chaining', true
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Gabriela Nanau" <Gabriela Nanau@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36F16EC4-7BFF-421B-B397-2BEB931FF1ED@xxxxxxxxxxxxxxxx
SQL Server 2000, SP4. I have this login MyLogin which has access in both
msdb
and master. The account is public in master and db_owner in msdb. I have
the
same settings on 10 servers. I attempt to create a job, steps and
schedule.
When it comes to msdb.dbo.sp_add_jobserver I got the following messages:
Msg 229, Level 14, State 5, Procedure xp_sqlagent_is_starting, Line 7
EXECUTE permission denied on object 'xp_sqlagent_is_starting', database
'master', owner 'dbo'.
Msg 229, Level 14, State 5, Procedure xp_sqlagent_notify, Line 175
EXECUTE permission denied on object 'xp_sqlagent_notify', database
'master',
owner 'dbo'.
The puzzling part here is that I got the errors on 2 servers out of the 10
above mentioned. On the other 8 the job is created successfully and there
are
no explicit rights granted or denied on these particular XPs.
Question: What are the minimum requirements to execute the above 2 XP?
They
are not documented by Microsoft or it seems I cannot find much on them.
There
is always the possibility to explicitly GRANT access to them for MyLogin,
but
the question remains: why is it working on 8 servers and not working on
the
other 2. Must be some other setting somewhere!
Any answer will be higly appreciated.
- References:
- Re: Execute permission denied on object xp_SQLagent_notify
- From: Dan Guzman
- Re: Execute permission denied on object xp_SQLagent_notify
- Prev by Date: Re: Password is "too recent to change"
- Next by Date: Re: Password is "too recent to change"
- Previous by thread: Re: Execute permission denied on object xp_SQLagent_notify
- Next by thread: Accesing data from many applications.
- Index(es):
Relevant Pages
|
|
