SQL Server cross-network segment FTP replication across the computer room

I. BACKGROUND

When you build SQL Server replication, if the network environment is within the LAN, through the host name can be achieved, but if it is across the network segment, across the computer room to build replication when you need to pay attention to, because SQL Server replication does not support through IP connection Distributor, then what method to solve the cross-network segment, What about the cross room problem?

I am in the SQL Server across the network segment (across the engine room) replication has already mentioned two solutions, if you want to use the request subscription mode, sharing the snapshot file permissions configuration is more cumbersome, a better and more secure way is to read the snapshot file through FTP initialization;

Second, build the process

(i) Environmental information

System environment: Windows Server 2008 + SQL Server 2008

Publisher: 192.168.1.101,1924, server name: User-h2b2a89pek

Distributor: Same machine as publisher

Subscriber: 192.168.1.102,1433, server name: QuZhoushiwei105

Publish database: Task

Subscription database: Tasksubscribe

Database account Number: Replicationuser/replicationpassword

FTP Address: ftp://192.168.1.101:9721

FTP account password: Ftpuser/ftppassword

(ii) Steps to build

Before starting the following steps you need to make sure that your FTP address is available and that you can read and download the generated snapshot files using the FTP client program;

A. Publisher configuration

The following are specific steps to set up the publishing server:

(Figure1: Select Publication database)

(Figure2: Transactional publication)

(Figure3: Select objects)

(Figure4: Initializing subscriptions)