January 30, 2002 at 4:13 pm
<P>I'm having difficulty configuring two SQL Servers to replicate using
any type of ftp. I have a main/local to our network server and a remote
server (outside of the LAN), I am trying to create a pull subscription
from the remote to the local. I tried to create a snapshot to a ftp
server independent of the two SQL servers and got as far as a successful
connection but no files were transferred. I then configured the remote
SQL Server to as a ftp host with a ftp root directory where I get the
snapshot to write , I just can't get the Local or main SQL Server to see
the remote SQL Server and thus the snapshot location. Is there a known
method of doing this, with some precise steps???</P>
February 2, 2002 at 7:34 pm
I think the thing to do is ignore replicaton for the moment and see what it takes to get FTP to work. Consider asking your network admin for assistance, could be that the port is blocked.
Andy
February 9, 2002 at 12:56 pm
Is this on SQL 2000? I struggled with this very thing just this past week on SQL 2000, and found that on the client side path you have to include the 'ftp' folder that the snapshot automatically creates. For instance, if you specify to place the snapshot files in folder '\\server1\basefolder\folder1', where 'folder1' is a folder off the ftp root, then in the 'Client path to this folder from the FTP root' field you need to enter 'folder1\ftp', not just 'folder1'. It doesn't tell you that anywhere, but that's what worked for me.
On SQL 7.0, I never had to fool with ftp - replication worked just fine through the internet without any ftp service. I don't know why they changed it in 2000 - maybe a security thing.
Jay
Jay Madren
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply