Here is the context, in short. I have 2 remote sites with SQL Server 2005.
Each server can't see the other one. I need to replicate data between them.

I use MSSQL Management Studio with SQL Server Developer Edition.

When creating a publication, I can say that I want the snapshot to be put on
a FTP in the publication option. no problem here. When I want to create a
subscribtion, I must give the publication to use, and there is the problem
because I can't see the remote server.

The only thing I need to do is to say the subscriber to take the snapshot on
the FTP, but I've not found how I can do this.

If someone can help me ^^

Thanks in advance.

P.S. : sorry for my bad english, I'm not very good with foreign language

Divid,
you'll need some sort of connectivity. This could be a VPN, HTTPS or just
TCP/IP (non-trusted). Somehow, the subscriber will need to contact the
publisher. If you want a purely FTP solution then you must use another
technology.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

VPN, in a wonderfull dream. Maybe one day ... or not

Merge replication can use HTTPS but the merge replication is not suitable in
my situation. Transactionnal replication can't use HTTPS as far as I know.

For the TCP/IP (non trusted), can you explain about this a little more. I
don't know what is it so maybe it could do the work.

Thanks again.

David,
this should help a bit:
http://www.replicationanswers.com/InternetArticle.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

It doesn't really help. I've add the alias but I can't add a "virtual"
publisher (the alias), and then I can't subscribe it, in Management Studio.
Seems that I'm only able to work on local because local publishing/local
subscribtion are the only options in Management Studio.

David,
unfortunately I can't repro this at the moment as we only have one SQL
Server 2005 installation. As soon as another is added I'll give it a go, but
hopefully someone else will take up the thread before then.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)