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

Getting the subscription ready

Our transactional replication is almost complete. We've already set up the distribution. We've also configured the publication. Articles are now ready to be propagated and distribution just needs to identify the subscribers.

We'll set up a third SQL Server box to act as subscriber, in this case SQL2012-03. As you can see, at this point, our subscriber server is empty:

Getting the subscription ready
  1. In the Object Explorer window, expand the SQL2012-03 object. Then, expand the Replication folder. Select and right-click on the Local Subscriptions folder, and select New Subscription.
  2. That initializes the New Subscription Wizard. Read the information on ...

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