sql server replication:
I aqm trying to set up merge replication over the Internet using FTP. M
subcriber always fail to access the site. Can anybody tell me what i a
doing very wrong?
it is sql 2000. I will apprecaite the steps necessary in setting u
Internet merge replication

bay
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message370436.htm

Hi
When you say that you are using ftp and internet, are you using dial up
connections?

I am going to assume you are using dialup connections as clients for this
answer.

1. Remember that on the internet, you do not have acces to a machine name
and your ip address changes regularly, thus you can't set it up as you would
on a lan. You might have noticed that SQL uses the name of the server and
publisher to try and connect to the server side machine, but of course this
fails over the internet. To overcome this, place the name od the server and
its IP address in the "hosts" file of your client machine (location =
c:\Windows\system32\drivers\etc). Once this is done, your client should
connect to the server successfully. Note that you will not be able to
initiate any action from the server side of this communication as the server
doesn't know what the IP address of the communicating machine is (from SQL's
perspective, that is). If I need to do something from server side, I usually
check the current IP of the client machine's connection, add it to the
server's hosts file and then do my actions. This only works till the
client's IP is changed (usually within 2 or 3 more connections).

2. If you get an "access denied" error message when the subscription is
"connecting to FTP site", try and access your ftp site using explorer and
the password you set up in your publication. If you can get in using
explorer, the subscriber will be able to get in. If not, you've found your
problem and you need to set up access permissions on your ftp site.

3. If you haven't set up your publication to allof ftp access, you do so by
right clicking on it and selecting the properties option and setting up the
"Snapshot Location" tab. Be sure to use a user name and password that have
access to your ftp folder. Use the name of the ftp site as the client path
from the ftp root. DO NOT USE THE ACTUAL FOLDER CONTAINING THE SNAPSHOT
FILE. If you do, you'll notice the pull subscription looking for additional
folders and not finding them. I keep my snapshot files in the default
location, so I just have my ftp site poing to ReplData, the subscription
adds \ftp\..... to the path automatically.

Hope this helps

Regards
Paul Kleynhans




[quoted text, click to view]