Tuesday, February 21, 2012 8:00 AM
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 ?
Tuesday, February 21, 2012 8:30 AM
I've missed adding the repl_snapshot windows user as login in SQL SERVER and make all apropriate settings on it.
- Marked As Answer by Hichem Sharaeen Tuesday, February 21, 2012 9:18 PM
Tuesday, February 21, 2012 3:54 PMModeratorEnable 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.