Developing Business Intelligence Apps for SharePoint

Chapter 40. SQL Server Reporting Services Configuration

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

  • Email configuration

  • Key management

• SQL 2012 SP1 enhancements

  • Leveraging EffectiveUserName

Provisioning Subscriptions and Alerts

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).

Figure 40-1. Subscribing to reports

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.

Figure 40-2. Enabling SQL Server Agent

In this screen, you will validate that the SQL Server ...