Configuring SSRS on the SharePoint Web Servers

This is the third post in the series Surfacing Company Data through Sharepoint 2007 and SQL Server 2008 Reporting Services. In the previous post titled Configuring the Report Server, we walked through an overview, the creation, and the configuration of the Report Server databases from the Report Server. In this article we’ll move on to the SharePoint side of things. We’ll cover an overview, installation, and configuration of the Reporting Services Add-in for SharePoint Technologies.

Step 1: Download the Reporting Services Add-in for SharePoint technologies to each web front end server in the SharePoint farm

• Note that there are different versions based on the 32bit or 64bit platforms
• http://www.microsoft.com/downloads/details.aspx?familyid=200FD7B5-DB7C-4B8C-A7DC-5EFEE6E19005&displaylang=en
• System Requirements
  1. Windows Server 2003 SP2, Windows Server 2008
  2. WSS 3.0 SP1 or MOSS SP1 or later
  3. Microsoft .NET Framework 3.0
  4. The web sites cannot use Anonymous access

Step 2: Install the Add-in to the web front end servers

1. On the web server open a command prompt
2. Navigate to the directory where you copied the rsSharePoint.msi
3. Type rsSharePoint.msi SKIPCA=1 and hit Enter
4. This installs the add-in in files only mode. This will get around a common error when double clicking the msi
5. Next go through the wizard – The webparts, application pages, and features are now installed
6. Repeat on all servers in the farm that host the web application role

Step 3: Configure Reporting Services in Central Administration

1. Open Central Administration
2. Click on Application Management
3. You should see a new section called “Reporting Services”. If you do not:
   1. Click Site Actions > Site Settings > Site Collection Features
   2. Click Activate for the Report Server Integration Feature
      
   3. Go back to the application management page and you should see the “Reporting Services” section
4. Click on Manage Integration settings
5. Enter in the Report Server Web Service URL you specified in the report server settings
6. Select the authentication mode – Use trusted account instead of Windows authentication if you are not using Kerberos authentication
   
7. Click OK
8. Once back on the Application Management page, click Grant database access
9. Ensure that the server name of the report server is correct and click OK – This will retrieve the Report Server’s service account information and grant that user rights to the SharePoint Configuration and Content databases
10. If you did not create a named instance when running the Report Server Configuration utility, leave “Default instance” selected
11. Click OK
12. An Enter Credentials dialog will open, enter in credentials to connect to the Report Server (A local administrator on the Report Server machine)
13. Click OK
14. Once you are back on the Application Management screen, click Set server defaults