Replication

  • Trying to set up replication (transactional) between two servers. Get error message that says 'can not start agent at subscriber'. What am i doing wrong?? Any assistance would be greatly appreciated.

    Grant

  • What agent are you talking about, distribution agent, snapshot agent, SQL Server Agent?.

    And when does this error shows up? Do you already have the publication created?

  • Followed the steps in configuring the publisher and distributor (same sever). Created the publication then want to push it to the other server. Snapshot occurs, but get message in "Last Action" column saying - 'connecting to subscriber' then 'the process could not connect to subscriber'

  • what type of authentication are you using to connect with the distribution agent?

    You can check that in the job of the distribution agent, in the second step, check the -DistributorSecurityMode and -SubscriberSecurityMode.

    Also check if there is any login specified.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply