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

Provisioning subscriptions and alerts

Another useful feature of the Reporting Services and SharePoint integration is the ability of the system to handle subscriptions and alerts. This is not really new, because, we have the same features on the SSRS Report Manager. But this is handy since you don't have to configure things like this somewhere else.

Let's configure the SQL Server Agent:

  1. Click on the Provision Subscription and Alerts link from the message we got when we created the service application.
  2. That displays the Provision Subscription and Alerts – SQL Reporting Application dialog box.
  3. Click on Download Script to download the SQL Reporting Application, GrantRights.sql file from your SharePoint server (SP2013 in my case). Save the file in an accessible ...

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