Configuring Replication Publishing
After the distribution database has been successfully installed, or you have been given permission to publish to a remote distribution server, you can then configure a server to be a publisher.
NOTE
To set up SQL Server as a publisher, you must have one of the following:
A local distribution database
Access to a remote distribution database
If you have a local distribution database on your server (that is, your server is acting as a distribution server), you can perform the following:
Set distribution working directory
Allow other servers access to your distribution database for publishing
Both distribution servers and publisher servers can control which servers allow access to published articles and which databases ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
