Re: Execute permission denied on object xp_SQLagent_notify

Gabriela,

On my server the xp_sqlagent* stored procedures are granted execute to
public. Check on your two problem servers to see whether that is true for
you.

If the agent XPs are not enabled, you can do so by:
sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Agent XPs', 1;

GO

RECONFIGURE

GO


RLF
"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.


.

Relevant Pages

  • Re: Return Code from Win32_Processs Create method
    ... > servers, so I can't use Win32_ProcessStopTrace class, as mentioned in ... > Dim objWMIService, intProcessID, intReturnCode ... > ' /* WMI Binding okay, so now execute the process ... > Wscript.Echo "WMI Binding Error: Process execution could not occurs due to ...
    (microsoft.public.scripting.vbscript)
  • RE: DBD::Oracle and ORA-600 [16365] errors
    ... > programand execute them in the same manner as an on-line ... Basically, the database would run out of servers and fail, and there was ... So, MTS was the ideal solution, apart from this crash issue:-/ ...
    (perl.dbi.users)
  • Dont Understand login script location..
    ... created a login script under the "Default domain policy" OU, ... the servers, but how do you get it to execute on w98 systems, the following ...
    (microsoft.public.windows.server.scripting)
  • EVENT ID:1000, SOURCE: USERINIT ERROR
    ... the MSKB site. ... "could not execute the following script ... Also my logon.bat script works just fine with my ... servers and PC's, but on every PC and server I get that error msg. ...
    (microsoft.public.win2000.general)
  • Run Logon Script on Workstations Only
    ... I am creating a script that I want to run at logon in a Windows NT ... but want it to execute on Windows 2000 or XP Professional ... Workstations only, not on Servers. ...
    (microsoft.public.scripting.vbscript)