"Paul" <pkleynhans@yahoo.com> wrote in message
news:2447b01c38cdb$bb224e60$a601280a@phx.gbl...
> Hi
> I've recently implemented Merge replication on my network.
> Over the LAN it works fine. My SQL 2000 server is
> configured as both publisher and Distributor.
>
> I need to enable this replication via Dialup, however,
> which means going through the company firewall. I've
> opened port 1433 and 1434 for communication to allow
> connecting to the SQL database directly, and this seems to
> work fine, but for some reason the Replication no longer
> works via dialup. (I can connect to the database and work
> on it using Enterprise manager via dialup, but the
> replication itsself doesn't work).
>
> I keep getting an error stating "Could not connect to
> Distributor "SERVER1"". This leads me to believe that my
> replication is connecting to the publisher successfully,
> but that something is preventing it from connecting to the
> Distributor.
>
> Via Dialup I have to use my server IP address to reach the
> server, but I still use the SQL Server name when actually
> connecting to the publisher as it doesn't seem to make a
> difference (I tried using the IP only, but the error stays
> the same).
>
> 1. Does anyone have suggestions as to what might be
> causing the replication to fail?
> 2. Are there additional ports to open to facilitate
> replication through a firewall?
>
> At this stage, any suggestions would be appreciated.
>
> Regards
> Paul Kleynhans