Non-SysAdmins ... proxy account

From: John Celery (celerygenerals_at_yahoo.com)
Date: 01/25/04

  • Next message: John Celery: "Non-SysAdmins ... proxy account"
    Date: Sun, 25 Jan 2004 14:32:15 -0800
    
    

    Error:

    Non-SysAdmins have been denied permission to run
    replication jobsteps without a proxy account. The step
    failed.

    &&

    Executed as user: Jobz. Replication-agentclassname: agent
    cb-desktop\cbx-NEWBIE-NEWBIE_pub-CB-DESKTOP\CBX-9 failed.
    Non-SysAdmins have been denied permission to run
    replication jobsteps without a proxy account. The step
    failed. [SQLSTATE 42000] (Error 14151). The step failed.

    What I have:

    Calling a Job with user 'Jobz', 'Jobz' owns this job so it
    IS getting called.

    2 of the 3 steps are failing because 'Non-SysAdmins have
    been denied permission to run replication jobsteps without
    a proxy account'

    How do I configure this proxy account so that running
    replication jobsteps will succeed with a user other then
    sa ?

    Thanks,
    John C.


  • Next message: John Celery: "Non-SysAdmins ... proxy account"

    Relevant Pages

    • RE: Non-SysAdmins ... proxy account
      ... "Non-SysAdmins have been denied permission to run ... replication jobsteps without a proxy account. ... How do you make it so that Non-SysAdmins are allowed ...
      (microsoft.public.sqlserver.security)
    • Permision settings - Non-SysAdmins
      ... "Non-SysAdmins have been denied permission to run replication jobsteps ... without a proxy account. ... What sould I do? ...
      (microsoft.public.sqlserver.replication)