Merge replication Over Internet

Have a look in the articles section of
www.replicationanswers.com - I have a posted up an
article there on just this topic.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul
Thanks for such a wonderful article, Actually I am facing a problem, you could see it as I have posted it on the group.
Actulally some days before I was implementing merge replication over internet, during that time I didn't even provide the netbios name of the remote MSDE server on the subscriber MSDE server and it worked fine.
but now on a new set of MSDE servers even if I enter all the information as you said I could not even connect to the remote server using osql facility.
Pls Pls Pls help me out I have already spent 3 days on this problem and getting frustated with each passing moment.

Quote:

Originally posted by Paul Ibison
Have a look in the articles section of
www.replicationanswers.com - I have a posted up an
article there on just this topic.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

|||Hi Paul
One more query if you could solve my doubt.
Actually while impletmenting replication over internet, I am planning to use dynamic filtering, Since we don't want to provide FTP information to over subscribers (which are obviously at distributed locations).
So I am asked to make sure that Snapshot is applied manually at the sbuscribers side, Since I am not having very much idea about how to Create Dynamic snapshot and apply it manually, Plz guide me?
Is it that If I apply snapshot manually I'll not need to specify all FTP related stuff??

Quote:

Originally posted by rdhar
Hi Paul
Thanks for such a wonderful article, Actually I am facing a problem, you could see it as I have posted it on the group.
Actulally some days before I was implementing merge replication over internet, during that time I didn't even provide the netbios name of the remote MSDE server on the subscriber MSDE server and it worked fine.
but now on a new set of MSDE servers even if I enter all the information as you said I could not even connect to the remote server using osql facility.
Pls Pls Pls help me out I have already spent 3 days on this problem and getting frustated with each passing moment.

|||For a manual snapshot, you don't need the FTP settings to initialize,
however, any additional articles added to the publication will cause
problems.
I can't setthis up today, but if you're having problems with manual
application of dynamic snapshots, then yo could disable the dynamic snapshot
bit and have the filters applied to the whole snapshot. It ends up the same,
but will take longer.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Can you ping the remote server or probably ping is disabled so can you
telnet it using port 1433? IE is it 'visible' at all through firewalls.
Can you connect using the IP address in OSQL? If so, have you created the
client network alias?
Are you using a VPN? Is it FTP or fileshare initialization? Question for
initialization configuration.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)