Configuring a Subscription to Use FTP to Retrieve a Snapshot

SQL Replication

Replication

Configuring a Subscription to Use FTP to Retrieve a Snapshot

After a publication has been enabled for publishing on the Internet, you must create a pull or anonymous subscription to the publication. Subscriptions using the Internet are created the same way as other subscriptions. The only difference in subscribing to a Publication over the Internet is that you must also configure the FTP addressing properties (FtpAddress, FtpPassword, FtpPort, and FtpUserName) for the Distribution Agent or Merge Agent to use.

You can configure the FTP addressing through SQL Server Enterprise Manager on the Snapshot Location tab in Publication Properties.