May 26, 2009 at 1:42 am
Dear All,
From our Business point of we have some specific requ. for replication.
1) I created transactional replication for our database for specific requirement during our ETL job.
2) our business has one SQL login like 'xyz' which we run the ETL job.
3) We created the procedure to start and stop the replication using msdb system tables and it worked fine using the sysadmin right.
4) When create the replication it create the 3 jobs for replication.
- Distributor Agent
- Log Reader Agent
- Snapshot Agent.
5) We change the owner of all three jobs to 'xyz' user for start and stop the distributor and log reader agent.
4) We added SQLAgentOperatorRole to xyz user not sysadmin to start and stop other running jobs.
5) but still facing the error like...
Unable to start execution of step 2 (reason: JobOwner recgen_etl doesn't have permissions to use proxy 44 for subsystem LogReader). The step failed.
Thanks,
🙂 🙂 🙂
Amey ghag
<a href='http://' class='authorlink' target='_blank'></a>
May 26, 2009 at 2:14 am
Have you looked at the post below?
May 26, 2009 at 2:50 am
No used.
Still getting same error i enter user in sysproxylogin table but now replication start and stop successfully. but from replication monitor showing the error.
🙂 🙂 🙂
Amey ghag
<a href='http://' class='authorlink' target='_blank'></a>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply