Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have successfully set up Replication. The problem is Snapshot Agent won't start. When I try to start it manually I always end up with "The agent has never been run."

Publication runs under the service account - db_owner in source db for the Publication, msdb, distribution db and with read/write permissions to snapshot folder.

I'm asking for suggestions how to deal with this situation. Thank you.

share|improve this question
There will be additional details in the verbose agent log. Add the parameters -OutputVerboseLevel 2 -Output C:\TEMP\snapshotagent.log to the Snapshot Agent Run Agent job step, re-run the Snapshot Agent, and collect the log. Inspect the log for additional details. They error should be found near the end of the log. –  Brandon Williams Jan 23 at 16:59
Thank you for tip. It was my mistake. Service account was not db_owner in distribution db after all. –  Rutz Jan 23 at 22:37
I'm glad to hear figured it out. –  Brandon Williams Jan 23 at 22:39
add comment

closed as off-topic by Jack Douglas Jan 23 at 22:44

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Jack Douglas
If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

up vote 1 down vote accepted

It was my mistake. Service account was not db_owner in distribution db after all.

share|improve this answer
Thanks for coming back and letting us know: I've closed hte question as it's unlikely to directly help another user. –  Jack Douglas Jan 24 at 7:15
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.