Wednesday, March 7, 2012

REMOTE DISTRIBUTOR / FTP SETTINGS

Hello.
I have this problem.
I have 2 servers X and Y.
X is only Publisher
Y is Publisher and Distributor for X and Y.
My question. When i make a publication in X, do i have to set the ftp server
parameter for the snapshot in X or Y.
I'm having errors on Connections.
Thanks in Advance
The ftp server can be anywhere, publisher, subscriber, distributor or
another server altogether. What you need to be able to do make sure the ftp
server has the snapshot files and the subscriber can resolve the ftp
servername. This is normally done by creating a snapshot share on the
distributor.
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
"Jose Fernandez" <ppcuban@.hotmail.com> wrote in message
news:OJdjyFqLGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hello.
> I have this problem.
> I have 2 servers X and Y.
> X is only Publisher
> Y is Publisher and Distributor for X and Y.
> My question. When i make a publication in X, do i have to set the ftp
> server parameter for the snapshot in X or Y.
> I'm having errors on Connections.
> Thanks in Advance
>
|||Jose,
I'm not too sure I follow. The FTP settings are on a publication basis is
SQL 2000/2005. In SQL 7.0 they were done on a subscription basis.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment