Creating a Distributor and Enabling Publishing

Before setting up a publisher, you have to designate a distribution server to be used by that publisher. As discussed earlier, you can either configure the local server as the distribution server or choose a remote server as the distributor (not on the same machine as the publication server). You can configure the server as a distributor and publisher at the same time, or you can configure the server as a dedicated distributor on the remote server separately. In the sample topology described here, you start by creating a remote distributor separately so you can orient yourself to what is happening on each server in the topology as it is being built up. You are also able to enable a specific SQL ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.