O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

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

Setting up the distributor

The first step in implementing a transactional replication is setting up the distribution. Actually, the general steps are similar in all other types of replication, although there are additional steps to take in the other types:

  1. Open the SQL Server Management Studio (SSMS). Typically, you have three separate servers setup for the publisher, distributor, and subscriber. In these demonstrations, these roles are assigned to SQL2012-01, SQL2012-02, and SQL2012-03 respectively.
    Setting up the distributor
  2. Expand the SQL2012-02 server object in the Object Explorer window. Select and right-click on the Replication folder, and select Configure Distribution ...

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