snapshot agent doesn't start

Question

Hi,

I've installed a merge replication on the publisher, the snapshot agent monitor is still showing the "starting agent" on Last Action column for about 7 minutes.

Am I missing something ?

Answer 1

Of course,

I've missed adding the repl_snapshot windows user as login in SQL SERVER and make all apropriate settings on it.

So Sorry.

Answer 2

Enable verbose agent logging and see where it is getting stuck.  Add the parameters -OutputVerboseLevel 2 -Output C:\TEMP\snapshotagent.log to the Snapshot Agent job.  Rerun the snapshot agent job and collect the log.  This should give you a better idea of what is going on.

---

Brandon Williams (blog | twitter)