RE: Non-SysAdmins ... proxy account

From: John Celery (anonymous_at_discussions.microsoft.com)
Date: 01/28/04


Date: Wed, 28 Jan 2004 12:01:53 -0800

Running the stored proc worked for a bit, but then when
back to: "Non-SysAdmins have been denied permission to run
replication jobsteps without a proxy account. The step
failed."

I don't think http://support.microsoft.com/?id=818552 is
the solution to this problem.

How do you make it so that Non-SysAdmins are allowed
permission to call replication jobsteps ?
(sql server 2000 sp3)

is this the best way for a client to invoke a merge agent ?



Relevant Pages

  • Non-SysAdmins ... proxy account
    ... Non-SysAdmins have been denied permission to run ... replication jobsteps without a proxy account. ... Executed as user: Jobz. ...
    (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)
  • Run job
    ... error message "Non-SysAdmins have been denied permission ... to run CmdExec job steps.". ... run a job rather than local admin/domain admin. ...
    (microsoft.public.sqlserver.security)