Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

1265


Chapter 56: Confi guring and Administering Reporting Services


56



  1. As the last step of this section, choose a database authentication method.
    Windows authentication is the recommended method.

  2. In the fi nal section, Web Application Association, click the radio button next to
    the web application to which you want to map this service application. The web
    application is now confi gured to host reports.


Deploying Reporting Services Reports


This section explores the options and strategies to deploy the reports to the report server.
Deploying directly from the development environment, SQL Server Data Tools (SSDT) is the
simplest method for the developer, but it may not always be possible or wanted depending
on confi guration and security constraints.

Deploying Reports Using SSDT
Deploying reports using SSDT requires some basic confi guration of the Reporting Services
project. When confi gured, reports (and other resources such as data sources and images)
can be deployed individually or the entire project can be deployed.

To confi gure the deployment properties for a Reporting Services project, open the project’s
property page by right-clicking the Reporting Services project and selecting Properties.
Figure 56-3 shows the property page for a Reporting Services project, and Table 56-1 summa-
rizes the deployment properties available for a Reporting Services project. You can deploy to
either the native mode Report Manager or a SharePoint integrated mode server using SSDT.

FIGURE 56-3
Use the settings on the property page of a Reporting Services project to confi gure the
deployment options.

c56.indd 1265c56.indd 1265 7/31/2012 10:34:16 AM7/31/2012 10:34:16 AM


http://www.it-ebooks.info
Free download pdf