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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

closed as off-topic by Jack Douglas Jan 23 '14 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.

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 '14 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 '14 at 22:37
I'm glad to hear figured it out. – Brandon Williams Jan 23 '14 at 22:39
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 '14 at 7:15

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