20160715001-Distribution and subscription summary

1. Trust the two SQL servers that are not in the same network segment or domain, and use the instance right-click on "register" mode.

2. For SQL Server that does not have access to the publishing host, the Subscriber uses the method of modifying the host file for mapping, for example: 192.168.1.6 pm-server.

3. The FTP service is built on the publisher, the publishing directory and the FTP directory are the same, but the FTP folder is created automatically under the publishing directory.
FTP subscription Format:/FTP, the Subscriber can read and write FTP server files (ftp://192.168.1.6 save password Settings).

4. Publish and subscribe run Settings all use SA account and process account, do not use Windows System account.

5. Subscribers and Publishers establish the same system login user, establish the same SQL login user, the Publisher SQL Agent service runs with this same SQL account (in configuration or service settings).

6. When publishing settings are published, you cannot use previous or previous published names, even if you have deleted the publication name.

20160715001-Distribution and subscription summary