I was stumped on the above error when configuring distributor afresh using SSMS. Eventually found that this is due to impersonate settings that were not setup, so to resolve this simply: Right click local publicaiton->Distributor properties Select the publisher in the list, click ... In agent connection mode, select ''impersonate the agent ...

There are few simple steps involved to monitor the replication actvites, as usual with Replication Monitor is useful to monitor the overall health of a replication topology. Replication Monitor provides detailed information on the status and performance of publications and subscriptions, allowing you to answer common questions, such as ( BOL ): Is ...

I was able to install SQL 2008 July CTP as a Virtual Image, tried to test few replication tasks to know what has been changed since last versions. At this time I would like to use the replication scripts from SQL 2000 version to see what it takes, nothing much I believe compared from 2005 to 2008. While going this replication security process gone ...