O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required