Re: FTP Replication SQL Server 2005
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Tue, 24 Jul 2007 17:06:41 -0400
set up the snapshot directory or the alternate snapshot directory to map to
the physical root or a subdirectory in your ftp server, or to a virtual root
in your ftp server.
Note that this ftp server does not have to exist on your SQL Server.
Then enable your publication for ftp subscriptions and make sure your root
or virtual directory ends in /ftp
Enter the ftp account in the publication properties.
Make sure that the SQL Server agent account or the account your snapshot
agent runs under has write, read, and list files and folders on the ftp root
or ftp virtual root.
Then create your subscription to download the snapshot via ftp.
--
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
"Jas" <Jas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:73CD7211-2670-4100-9E54-A5448A21CF50@xxxxxxxxxxxxxxxx
Hi, is there any documentation on how to setup a replication with SQL
Server
2005 using FTP Snapshot?
What is needed? We are trying to setup replication between 2 computer on
a
different domain and in couple month 3 more computers will replicate to
the
server too so using a username and password for the sql server agent is
not
the good thing for us.
After trying for the first time we are getting the error: the replication
agent failed to create the directory.
Does anyone had the same error and how to resolve this?
Thanks
.
- Prev by Date: SQL 2005 Web Synch Replication Issues/Questions
- Next by Date: Re: What topology is better ?
- Previous by thread: SQL 2005 Web Synch Replication Issues/Questions
- Next by thread: Can subscriber be a partitioned view?
- Index(es):
Relevant Pages
|
