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™ 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 during the default SQL Server Setup but may not have been enabled if you did a custom installation. You must also set the FTP home directory to the snapshot folder to be the FTP home directory (by default, \\Mssql7\Repldata\Ftp) and configure the FTP home directory as an FTP site.

To enable TCP/IP or Multiprotocol

To set the snapshot folder as the FTP home directory

To configure the FTP home directory as an FTP site

See Also