In this chapter, we will focus on the configuration settings in SQL Server Reporting Services (SSRS) that will make this functionality work optimally. (See details on installation of SQL Reporting Services Integrated Mode in Chapter 35.)
This chapter covers:
Current version configuration
Provisioning subscriptions and alerts
SQL 2012 SP1 enhancements
One helpful feature that was released with SQL Server 2012 is the ability to set up subscriptions and alerts in SQL Server Reporting Services Integrated Mode. This new feature allows users to set notifications and regularly deliver reports via email, network share, or a SharePoint library.
From a report, click on the Actions menu and you will see New Data Alert and Subscribe options (see Figure 40-1).
In order to support this new functionality, you must first configure the Service Application settings in Central Administration by going to Application Management and selecting the Reporting Services Service Application.
The first setting that needs to be configured is the SQL Server Agent access (Figure 40-2). This is done using the Provision Subscriptions and Alerts screen.
In this screen, you will validate that the SQL Server ...