Configuring a Subscription to Use FTP

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 by selecting Use the File Transfer Protocol (FTP) when downloading snapshot files from the Distributor on the Snapshot Delivery tab of the subscription Properties dialog box. You can also set the FTP address information programmatically through the Microsoft® Active X® controls. You can use either the actual IP address through the Distributor name or a name that is resolved to a domain name through DHCP.

To create a new subscription over the Internet

To modify an existing subscription to use the Internet

See Also