Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

 Note As with the majority of server-based software, SharePoint 2010 and SQL Server 2012 have prerequisites

that must be met before a successful installation occurs. These requirements can change over time, so it is always

best to verify the prerequisites before setting out to install the software. For example, SharePoint 2010 needs to be

installed on a server-based operating system like Windows Server 2008. It also requires Service Pack 1 to be

installed and a minimum of 4GB of ram and 80 GB of disk space. The server must be configured as a Domain

Controller. Those are just a few of the requirements, but you can see more SharePoint requirements at

http://technet.microsoft.com/en-us/library/cc262485.aspx and SQL Server Reporting Services

requirements at http://msdn.microsoft.com/en-us/library/gg492276(v=sql.110).aspx.

Assuming that all of the prerequisites, software and hardware requirements have been met then

there are six major steps to complete a stand-alone installation of SSRS and SharePoint:

1. Install SharePoint 2010 with Service Pack 1.


2. Install SQL Server 2012 Database Engine and Reporting Services in SharePoint
   mode.


3. Configure SharePoint 2010.


4. Install and start the Reporting Services SharePoint Service.


5. Create a Reporting Services Service Application in SharePoint Central
   Administration.


6. Configure Reporting Services Integration with SharePoint.

Installing SharePoint 2010

We will start by walking you through the installation of SharePoint 2010 with Service Pack 1. Installing

SharePoint 2010 is a straightforward process, with the exception of the final step, where the installation

wizard asks you if you want to Run Configuration Wizard (Figure 12-12). This option button is selected

by default, but in the case of Reporting Services in SharePoint integrated mode, you will configure it

later. You’ll configure SharePoint after you have installed an instance of the SQL Server 2012 database

engine. Remove the check from the checkbox and click Close to complete the SharePoint 2010

installation.