December 15, 2008 at 8:30 am
Is the distribution_admin has been grant to both of the server?
I think the problem is because the distribution_admin user (default user for replication), doesn't have privilage to the replication
December 15, 2008 at 10:47 am
Yes I added distributor_agent on both servers and gave sysadmin role.
I deleted all replications and started again from the beginning .. Now I am gettinf a new error, Snapshot agent is showing as running then after 10 min , it is failing with the error message
" The agent is suspect. No response within last 10 minutes". Any idea why this is happening?
could you please give me the step by step instructions for transactional replication. I am doing this for the first time.
thanks
December 15, 2008 at 5:02 pm
Above error is fixed now. But log reader is failing again after some time. This step did not generate any output . When I right click and start agent it is running again but why is it failing otherwise?
Thanks
Any idea?
December 16, 2008 at 9:12 am
Hmm... I think this is because of the security agent...
Okay, right click on the replication -> properties
On the properties windows select the snapshots agent security, and filled with the right one (user id and password)
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply