Solved

SQL merge replication failure

Posted on 2009-05-15
6
163 Views
Last Modified: 2013-11-30
I have setup pull database merge replication between remote 2000 servers with sql2000. I don't get any errors until I try to start replication. This is the error I get from the snapshot agent.

The prosess could not create the file     \\servername\D$\repldata\unc

The network path was not found, error 53

How do I fix this.
0
Comment
Question by:jimmylew52
  • 3
  • 3
6 Comments
 
LVL 6

Accepted Solution

by:
bull_rider earned 500 total points
Comment Utility
The network path is not a shared one. Culd you please check it and let me know?
0
 
LVL 1

Author Comment

by:jimmylew52
Comment Utility
I tried making a share and directing to the share but I get the error

The path was not found

and it won't let me use the path. If I get it to use the path I get the same error.
0
 
LVL 6

Expert Comment

by:bull_rider
Comment Utility
then the user who is resposible for the replication does not have the permissions to access that folder. give access to everyone on that folder and then check.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 6

Expert Comment

by:bull_rider
Comment Utility
0
 
LVL 1

Author Comment

by:jimmylew52
Comment Utility
Look like the URL could be the answer. Unfortunately the reason I am doing a pull with this database is a problem with drive space on the publisher and I cannot use the default location for the snapshot. So until the drive space issue is resolved I cannot try the solution.

Thank you for your assistance.
0
 
LVL 1

Author Comment

by:jimmylew52
Comment Utility
As to access rights I had set everyone to full control to make sure that was not the problem. That Did not help.
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.

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

763 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

12 Experts available now in Live!

Get 1:1 Help Now