by We have been attempting to get merge replication working for some 8 weeks
now.
We have tried:
SQL Server7 Enterprise Edition SP0, SP1 & SP2 with clients running MSDE SP0,
SP1, SP2 on Win95/Win98 & WinNT Workstation 4.0. IN all combinations. We
have also attempted multiple installations on different hardware and
relocated the server into a different internet connection. We are currently
running WinNTSp6a, SQL7.0 SP1 on the server and Clients are running with
SQL7.0 SP1 with the replication agent hot-fix supplied by Microsoft.
So far we have had mixed results with the download of the snapshot creation
falling over at different phases of the process. Initially we only saw the
process stop when downloading one of the *.sch files from the FTP server. We
investigated 'Black Hole' router's based on a Microsoft article and are now
running an MTU of 576 on the network interface and PMTU detection is turned
off. We have also set the 'Network Size' within SQLServer to 512. This has
had limited success with some clients able to download the snapshot. The
download process usually stops on different *.sch files and yes we have
checked the file permissions.
Microsoft support was unable to provide any real answers.
This is now critical and we well behind schedule. Any assistance would be
greatly appreciated.