Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 AdventureWorks Replication Problem

Author  Topic 

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2009-07-01 : 02:43:35
Hello, i'm trying to use the tutorial @ msdn about replicating adventure works, and i cant get it to start the agents...

i've completed the following steps:

Preparing the Server for Replications Lessons 1-3
Replicating Data Between two Fully Connected Machines 1

i got up to the "To view the status of snapshot generation"
part but the agent keeps saying it failed with the following error:
Executed as user: natimark4\repl_snapshot. A required privilege is not held by the client. The step failed.

i've tried to set up the Jobs Owner to be SA, that didnt work, i added the user accounts i created (per the tutorial) to admin, they were already added to share permissions... Nothing wants to work...

Any Help?

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2009-07-01 : 21:30:52
[url]http://eventid.net/display.asp?eventid=14151&eventno=9693&source=MSSQLSERVER&phase=1[/url]

works perfect!
Go to Top of Page
   

- Advertisement -