O'Reilly logo

Developing Business Intelligence Apps for SharePoint by David Feldman, Jason Himmelstein

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

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

Subscribing to reports
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 ...

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