We currently use merge replication as a part of our
software product. We have approx 130 individual
subscribers with anonymous pull subscriptions at various
locations in Australia and New Zealand. The subscribers
use TCP/IP over the internet for replication, via a
variety of connections eg Dial Up, DSL, Cable etc.
The Publisher is SQL2000 SP1 and subscribers are MSDE 1.0
We are planning to upgrade the subscribers to MSDE 2.0 to
benefit from the performance gains.
In our testing when we have upgraded the clients to
MSDE2.0 and created new subscriptions to a new
publication, any client that is not on the local LAN
generates the following error - i.e all 130 subscribers
2. Connecting to Publisher
3. Bulk Copying Data into 'sysmergesubsetfilters'
4. Process could not deliver snapshot to subscriber
If we use the local LAN and not a dial up connection the
error is not generated.
Moreover if the snapshot is delivered via the LAN, we can
use a dial up account to replicate with no problems.
We think it is one of the replication components trying to
do a reverse DNS lookup for the location of the FTP server
where the snapshot files are located.
We have read KB article (Q300420) and implemented the
suggestions with no luck.
Any help would be greatly appreciated.