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

Configuring the publication

The next step, after setting up distribution, is publication. This is the part where we select the objects that we want to propagate to the subscriber. In the distribution, we set up SQL2012-01 as the publisher. So, let's go to that server and configure the publication:

  1. In the Object Explorer window, expand the SQL2012-01 object. Then, expand the Replication folder. Select and right-click on the Local Publications folder, and select New Publication as shown in the following screenshot:
    Configuring the publication
  2. That initializes the New Publication Wizard. Read the information on the dialog. Click on Next.
  3. On the select Distributor step, select the ...

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