Remote Login errors

• Deni Kusdeni

  Default port

  Points: 1457

  More actions

  December 15, 2008 at 8:30 am

  #912488

  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

• SQLdba-617800

  SSCommitted

  Points: 1586

  More actions

  December 15, 2008 at 10:47 am

  #912651

  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

• SQLdba-617800

  SSCommitted

  Points: 1586

  More actions

  December 15, 2008 at 5:02 pm

  #912880

  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?

• Deni Kusdeni

  Default port

  Points: 1457

  More actions

  December 16, 2008 at 9:12 am

  #913233

  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)