Desktop

Ask something
Discussion Locked

SQL Replication to an outside server

0 helpful
2 replies

by jcannon1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to setup a pull subscription from a SQL Server 2000 server that is outside my domain to one of my SQL 2000 servers. I can see both servers in the Enterprize Managers and connect, but when I try the subscription, the distribution agent fails saying that "the process cannot read a file". Please help.

2 replies

by joseph moore

According to Technet article Q240688, "This is a problem with the permissions on the replication snapshot folder on the distribution server. The anonymous subscriber needs Read access to the Repldata folder, which by default on a Distributor server running Microsoft Windows NT is the drive $ share and a path of \\ computer \ drive $\Mssql7\Repldata (for example, \\Machinename\D$\Mssql7\Repldata). This is an administrative share, and only accounts with Administrator privileges can access this folder."

The recommended fix is to create a public share (where everyone can get in), and configure the Distributor to use this share as its distribution point. Then, your SQL Server would connect over the share and pull down the subscription.

Please read the article for full details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240688
(please remove any spaces)

hope this helps

by jcannon1

I have an open share with read permissions to everbody on the publisher/distributor (same server) and I still can't do a pull subscription from the server that's outside my LAN. I am able to do a Push subscribtion, though. Don't understand.

This discussion is closed to new replies.