Re: SQL 2000, merge replication over FTP

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tony Toker (xyzzy_at_identic.co.uk)
Date: 11/04/04 

Date: Thu, 4 Nov 2004 10:35:55 -0000

FTP is simply for the trasnsfer of the initial snapshot. The snapshot could
be distributed in a variety of ways.

At a minimum you'll need your SQL Server TCP port (usually 1433) to be
available as well.

For all kinds of security reasons, if it's feasible, using VPN is a good
idea for internet replication.

TT

"Teemu Keiski" <joteke@aspalliance.com> wrote in message
news:ejNtWyjwEHA.2676@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I am setting up replication between two computers and over the Internet
> (FTP). Question, and a bit stupid such, is that do I need to have other
> ports than FTP 21 open for the server (would seem bit weird if it would,
but
> strill...)? I have tried the setup on LAN and I'm not sure if it works
only
> with the FTP port, seemed to have connectivity problems when closing all
> other ports than 21. Any pointers?
>
> --
> Teemu Keiski
> ASP.NET MVP, Finland
>
>

Relevant Pages

  • Re: Ports and Replication in SQL Server 2000
    ... If you don't use FTP SQL will download the snapshot from the default folder ... > different port to download the initial snapshot files. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2000, merge replication over FTP
    ... > FTP is simply for the trasnsfer of the initial snapshot. ... > idea for internet replication. ... >> with the FTP port, seemed to have connectivity problems when closing all ...
    (microsoft.public.sqlserver.replication)
  • RE: Telnet/ftp problems SBS2000
    ... Please make sure your client computers are configured as both Firewall ... will find two options "Enable folder view for FTP sites" and "Use Passive ... that the control connection has been successfully established, ... (other than port 21) ...
    (microsoft.public.windows.server.sbs)
  • FTP transfer port
    ... FTP transfer port ... the FTP server "listens" for client connections on its port 21. ... it will establish a separate control connection and data connection with ...
    (bit.listserv.ibm-main)
  • Re: Hacked? External address knocks on internal private address...
    ... The important part of your message is that FTP is allowed out... ... You open a connection to an FTP Server and logon. ... When you ask the server for a file the server issues a "PORT" command ... so it can open a port on the firewall to allow the incoming Data ...
    (comp.security.firewalls)