Solved

Replication Nightmare

Posted on 2004-09-03
4
497 Views
Last Modified: 2008-02-26
I have an SQL Server 2000 running as the publication and distributor.  I create a pull subscription on a pc that is running MSDE 2000.  I get errors of:
The process could not deliver the snapshot to the Subscriber.  The step failed.
Unable to open BCP host data-file
Unable to open BCP host data-file
The process could not bulk copy into table '"dbo"."MSmerge_contents"'.
The process could not deliver the snapshot to the Subscriber.
0
Comment
Question by:clangl
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
ShogunWade earned 250 total points
ID: 11990260
this usually occurs bvecause the subscriber does not have permissions to access the snapshot folder.
0
 

Author Comment

by:clangl
ID: 11995766
This is the Agent on the Subscriber... What I am assuming that I will have to do is create a group on the domain that has access to the snapshot folder then add the User that runs on the subscriber machine to that group???
0
 
LVL 18

Expert Comment

by:ShogunWade
ID: 12198210
oops sorry this one slipped though the net.     clangl,   if you still have the problem and need me to assist futher them please let me know.   If it is solved then I agree with the learned one.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

785 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