asked on

SQL 1005 - Replication Snapshot Job Error

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

Message
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.

phermi

ASKER

I forgot .. this is SQL 2005

ASKER CERTIFIED SOLUTION

AaronAbend

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

phermi

ASKER

AaronAden,

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.

phermi

ASKER

AaronAden,

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

http://support.microsoft.com/?kbid=911305

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.

Regards,

Pedro Hermida