Overview

This describes how to install and configure Microsoft SQL Server Reporting Services on an existing server that has SQL Server installed but not Reporting Services.

This guide applies to Microsoft SQL Server Reporting Services 2008 R2.

How To Install

To install Microsoft SQL Server Reporting Services:

1. Download the installation file (SQLEXPRADV_x86_ENU.exe) from http://www.microsoft.com/en-gb/download/details.aspx?id=26729.
2. Run the SQLEXPRADV_x86_ENU.exe installation.
3. From the SQL Server Installation Centre select "New installation or add features to existing installation".
   

   SQL Server Installation Centre

4. From the Installation Type screen select "Add feature to an existing instance of SQL Server 2008 R2", ensure that the correct instance of SQL Server is selected (the default is CALLRECORDER), then click on Next >.
   

   Installation Type

5. Check the Reporting Services option, then click on Next >.
   

   Feature Selection

   Server Configuration screen leave the defaults (to using the NETWORK SERVICE account) then click on Next >.
6. From the Reporting Services Configuration screen, check "Install, but do not configure the report server" is selected then click on Next >.
7. Click Next until the installation starts and the Installation Progress screen is shown.</>
8. The installation is complete once the Complete screen is displayed, click on Close.
   

   Complete

9. Follow the How To Configure steps to configure Reporting Services.

How To Configure

To configure Microsoft SQL Server Reporting Services once installed:

1. From the reporting server, from the Start Menu open Start -> All Programs -> Microsoft SQL Server 2008 R2 ->Configuration Tools -> Reporting Services Configuration Manager.
   

   Start Menu

2. From the Reporting Services Configuration Connection, enter the server name, click Find and select the correct instance (default CALLRECORDER), click on Connect..
   

   Connection

3. From the Service Account section select "Use built-in account" and select "Network Service", then click on Apply.
   

   Service Account

4. From the Web Service URL section set the Virtual Directory to "ReportServer_CALLRECORDER", and leave the other settings as default, then click on Apply.
   

   Web Service URL

5. From the Database section click on Change Database.
   

   Database

6. From the Action section, select the Create a new report server database, click Next.
   

   Change Database - Action

7. From the Database Server section, configure the server and database instance name, i.e. <servername>\CALLRECORDER, then click on Next.
   

   Change Database - Database Server

8. From the Database section, leave the defaults and click on Next.
   

   Change Database - Database

9. From the Credentials section, leave the defaults and click on Next.
   

   Change Database - Authentication

10. From the Summary section, review the settings and then click Next to save the changes.
11. When the process is complete click on Finish.
    

    Change Database - Finish

12. From the Report Manager URL section, check the Virtual Directory is set to "Reports_CALLRECORDER", click on Apply.
    

    Report Manager URL

13. Click on Exit to close the Reporting Services Configuration Manager.
14. From the Website configuration section set the Report Server URL to be http://localhost/reportserver_callrecorder.
15. The configuration is now complete.