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

  • I think it tried to start the SQL Server Agent at the subscriber. But it coudn't do it because of a login problem. Is the login account used on the sql server agent member of the same domain that the subscriber is?

  • racosta, thanks for the postings. Going to retry next week. Have in the mean time set up a job to DTS the whole database to the other server. This is time consuming but at least i know that it works. Will let you know if i get it working.

  • You have the option to run the agent on the publisher or subscriber, I usually use push (publisher) option, more as a preference than anything.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

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

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