Configuring a Publisher or Distributor to Listen on TCP/IP

SQL Replication

Replication

Configuring a Publisher or Distributor to Listen on TCP/IP

Before you can publish articles over the Internet, the servers where the Publisher and Distributor are located must be enabled to listen on either TCP/IP or Multiprotocol network protocol. Microsoft® SQL Server™ 2000 uses the TCP/IP Sockets or the Multiprotocol Net-Libraries over TCP/IP to establish an ODBC connection between the Publisher or Distributor on one side of the Internet and the Subscriber on the other. In pull or anonymous subscriptions to transactional publications, the Distribution Agent executes at the Subscriber and connects through the Internet to the Distributor to synchronize. In pull or anonymous subscriptions to merge publications, the Merge Agent executes at the Subscriber and connects through the Internet to the Publisher and Distributor to synchronize.

The TCP/IP Sockets Net-Library is enabled by default during the typical SQL Server 2000 Setup, but may not have been enabled if you performed a custom installation. You can specify the FTP paths and ports as the snapshot folder location under Publication Properties so that a server already configured as an FTP site is used as the snapshot folder location. Or you can set the snapshot folder to be the FTP home directory (by default, \Microsoft SQL Server\Mssql\Repldata\Ftp) and configure the FTP home directory as an FTP site.

To specify FTP information