SQL 1005 - Replication Snapshot Job Error

Posted on 2006-03-28
Last Modified: 2008-03-06
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)

Source            spid54

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.
Question by:phermi

    Author Comment

    I forgot .. this is SQL 2005
    LVL 10

    Accepted Solution

    What user are you using? You should not use localsystem. Use a windows account set up for the purpose of replication. That user will need privileges to start and stop services (Usually I use Administrator privs, but that is fairly broad and some companies will not allow that.. you'll need help from a windows security person if you want more info on that).

    Also, make sure the user has access to the replication directory on the publisher.


    Author Comment


    Because I am replicating between "un-trusted" SBS 2003 domains, I created an user SQLReplication that the SQL Server Agent is using to logon. Because of the error, I have made this user members of the Builin Administrators group as well as Domain Admins. From the DB perspective, by consecuence, it is a member of sysadmin. That user is the process account used under Agent Security for the Publication.

    Regarding the folder on the Publisher that is the same as the Distributor, SQLReplication has full control over C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\repldata wich contains "unc" and then inside the folder for the snapshot.

    I honestly do not what I'm missing. Thanks for your help. I hope you can guide me further.

    Author Comment


    I was lucky to come accross this article which addresses and fixes my problem:

    Being the only one who replied to me, I will assign the points to you.

    I hope I can count with your advice in the future.


    Pedro Hermida

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Introduction After workin in a plethora of programming languages like C, Pro*C, ESQL/C, C++, VC++, VB, Java, HTML,JavaScipt etc, technologies and frameworks like JSP, Servlets, Struts, Spring, IBatis etc and databases like MS Access, SQLServer, Inf…
    Read about achieving the basic levels of HRIS security in the workplace.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now