What does normal internet access mean? Port 80? Can it access the publisher
over port 1433? It doesn't sound like it. In fact it sounds like it can only
access port 21 (ftp). You will need to run your Publisher on port 21, and
have another ftp server running on port 21 which your publisher copies the
snapshot files to this ftp server.
When you create your publication right click on it, select snapshot location
and here configure the other ftp server.
Now your subscriber will access this ftp server to pull the snapshot.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com [quoted text, click to view] "krackq" <douggoodyear@yahoo.com> wrote in message
news:1154102643.900707.41520@m79g2000cwm.googlegroups.com...
> We have an sql server (server A) at a supplier that is windows 2003,
> running sql server 2000. Its only connection to the outside world is
> via normal internet access as any other pc there.
>
> Now, at our facility here (which is completely separate from theirs) we
> have an sql server (Server B) on windows 2003 server, running sql
> server 2000 that has its ftp port publicly accessible... that is, files
> can be ftp'ed into a directory on that server from the internet.
>
> Can set up replication between the two servers. That is, can I
> basically replicate a database on a regular basis from Server A to
> Server B so that the database on Server B is more or less an updated
> copy of the one on Server A? We're looking to be able to do reporting
> on the database on server A by having a copy of it on Server B at our
> facility (because server a is not available to anyone here).
>
> I've tried playing with a lot of the publication settings etc. The
> best I can figure out is how to make a snapshot of the database on
> Server A into a local ftp directory on Server A (keep in mind that even
> though Server A has ftp on it, its not available to anyone outside the
> company.. so I guess its, in effect, snapshotting just to a local
> folder). From there I can ftp the files to Server B since B has ftp
> services available. Now.. from here, I'm pretty much stuck. I dont'
> know how to subscribe (or even if I can) to these ftp'ed files.
>
> Is there a particular way I need to configure things on the publishing
> server.. and/or the subscribing server? Or am I trying to do something
> not possible here? I'm open for suggestions too as this is something I
> have to figure out. The whole idea is keeping a copy of Server A's
> database up to date here on Server B so we can run reporting against
> it.
>
> Thanks!!
>
