I am trying to setup a snapshot replication. I keep getting this error. I would appreciate if anyone can tell me what privileges I need for which user and/or the user used to logon the SQL Agent service.
Thanks in advanced.
Date 3/28/2006 2:42:15 PM
Log SQL Server (Current - 3/28/2006 2:42:00 PM)
Replication-Replication Snapshot Subsystem: agent KPI-kpi-KPI-1 failed. Executed as user: network4leaders\SQLReplication. A required privilege is not held by the client. The step failed.