Post reply

Issue to execute job - sp_start_job denied

  • August 13, 2010 at 2:55 pm

    #148435

    Hi,

    I has a user with 'SQLAgentOperatorRole' and 'TargetServersRole' permissions and it is db_owner in MSDB DB and it had EXECUTE permission on sp_start_job, but I am still getting the following error when the user want to execute a job:

    The Execute permission was denied on the object 'sp_start_job'.database msdb

    My server is SQL 2005 9.0.4035.

    Thanks in advance.

    Brownsea

  • August 17, 2010 at 1:40 pm

    #1208111

    brownsea (8/13/2010)

    Hi,

    I has a user with 'SQLAgentOperatorRole' and 'TargetServersRole' permissions and it is db_owner in MSDB DB and it had EXECUTE permission on sp_start_job, but I am still getting the following error when the user want to execute a job:

    The Execute permission was denied on the object 'sp_start_job'.database msdb

    My server is SQL 2005 9.0.4035.

    Thanks in advance.

    Brownsea

    try this:

    Grant ddl_admin rights to the user

    if that doesn't work try:

    ALTER DATABASE <<yourdb>> SET TRUSTWORTHY ON

    Alex S

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply