Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

Replication Nightmare

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
clangl
Asked:
clangl
  • 2
1 Solution
 
ShogunWadeCommented:
this usually occurs bvecause the subscriber does not have permissions to access the snapshot folder.
0
 
clanglAuthor Commented:
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
 
ShogunWadeCommented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now