FTP replication other 2 sql server 2000 (without IIS)

Hi everybody,
I want to setup a FTP replication ( snapshot or transactionnal) other 2
SQL 2000 server ( S1 and S2) accross non trust domains ( domain A and
domain B).
neither S1 , nor S2 can have IIS set. So i want to use an FTP server on
domain B to acts as snapshot folder.
Do you have some advices allowed me doing this.
RM : I read lots of method that use IIS on the publisher , but I can't
because neither S1 nor S2 can be reached other the web.
Thank you for reading me.
You can park your ftp server anywhere on your network as long as the
publisher and subscribers can reach it. The Publisher will have to be able
to do a local copy to a local drive or a network drive, so it will need
read, list files and folders, and write rights to the share or folder which
the ftp server is on. The subscriber will merely need to be able to access
the ftp site.
HTH
Hilary Cotter
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
<philippe.edmond@.gmail.com> wrote in message
news:1164819189.753714.312780@.h54g2000cwb.googlegr oups.com...
> Hi everybody,
> I want to setup a FTP replication ( snapshot or transactionnal) other 2
> SQL 2000 server ( S1 and S2) accross non trust domains ( domain A and
> domain B).
> neither S1 , nor S2 can have IIS set. So i want to use an FTP server on
> domain B to acts as snapshot folder.
> Do you have some advices allowed me doing this.
> RM : I read lots of method that use IIS on the publisher , but I can't
> because neither S1 nor S2 can be reached other the web.
> Thank you for reading me.
>
|||Thanks for your response.
I will try it.
On 29 nov, 18:12, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> You can park your ftp server anywhere on your network as long as the
> publisher and subscribers can reach it. The Publisher will have to be able
> to do a local copy to a local drive or a network drive, so it will need
> read, list files and folders, and write rights to the share or folder which
> the ftp server is on. The subscriber will merely need to be able to access
> the ftp site.
> HTH
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> <philippe.edm...@.gmail.com> wrote in messagenews:1164819189.753714.312780@.h54g2000cwb.g ooglegroups.com...
>
>
>
>

Ftp

Can somebody give me a complete picture about FTP task by VB or SQL SERVER 2000?I need to know every step.I have to do FTP task accross teo,three countries.Originally posted by subhasishray
Can somebody give me a complete picture about FTP task by VB or SQL SERVER 2000?I need to know every step.I have to do FTP task accross teo,three countries.

if u want to send or recieve file using FTP in a DTS package or using ActiveX script look at the attached files|||Originally posted by vmlal
if u want to send or recieve file using FTP in a DTS package or using ActiveX script look at the attached files|||if the FTP does not complete, network issue lets say? will the procedure end up as a failure or as a success?|||Originally posted by rohitkumar
if the FTP does not complete, network issue lets say? will the procedure end up as a failure or as a success?

Success i think but the downloaded file will be incomplete and there is no way to find that out. Unless you know the exact size of the file u r downloading and once it has been downloaed u check if the file downloaded is the correct size.

I have had this kinda problem where the FTP file transfer does not complete but the FTP session times - out.sql