Solved

Replication Nightmare

Posted on 2004-09-03
4
504 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

729 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