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.See the following kb for more info.
818552 BUG: Replication Agent Might Run Continuously Even When the
Replication
http://support.microsoft.com/?id=818552
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||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 ?
Friday, March 23, 2012
Non-SysAdmins ... proxy account
Labels:
database,
denied,
errornon-sysadmins,
executed,
jobsteps,
jobz,
microsoft,
mysql,
non-sysadmins,
oracle,
permission,
proxy,
runreplication,
server,
sql,
stepfailed,
user
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment