Solved

Replication Nightmare

Posted on 2004-09-03
4
494 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
tempdb latch contention 12 48
VB6 ListBox Question 4 32
MSDN Licensing query 5 0
conditional join based on column 4 0
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

910 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

20 Experts available now in Live!

Get 1:1 Help Now