Integrating Reporting Services 2008 with SharePoint 2007 Step 3 - Configuring Reporting Services for SharePoint 3.0 Integration - Part 1
Step 3 - Configuring Reporting Services for SharePoint 3.0 Integration - Part 1 : Operations performed with Reporting Services Configuration tool
The previous steps are:
- Step 1 - SQL Server 2008 with reporting Services Installation and Configuration
- Step 2 - SharePoint Installation
- Step 4 - Configuring Reporting Services for SharePoint 3.0 Integration - Part 2: Operations performed in SharePoint Central Administration (includes Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies Installation)
- Step 5 - Sample Databases for Microsoft SQL Server 2008 Installation
- Step 6 - Report Creation and Deployment in SharePoint 2007 with Business Intelligence Development Studio (BIDS)
The VM runs Windows 2003 Server OS
The goal is to quickly allow someone to create reports and to discover SharePoint Integrated Mode features: deployment, Web Parts dashboards, subscription, snapshotings, etc..
Even planning for further deployments in a Farm environment with several servers and Active Directory, it may be usefull to have been familiarized with involved products installation, configuration and use, by having tested it in a Simple Farm Topology with one computer and local accounts.
1 - Environment Configuration
|Number of Virtual machines:||1|
|Operating System:||Windows 2003 Server|
|Server Roles:||Application Server|
SQL Server Service Account: Local Administrator
Setup user account: Local Administrator
Server farm account/Database access account: Local Administrator
2 - Referred Documentation
You have installed and configured SQL Server 2008 with reporting services on the virtual machine with a Windows 2003 Server OS.
(if not you can refer to the step 1 of these arcticles group: Step 1 - SQL Server 2008 with reporting Services Installation and Configuration )
- You have downloaded Windows SharePoint Services 3.0 with Service Pack 1 and have installed it. If not you can refer to Integrating Reporting Services 2008 with SharePoint 2007 Step 2 - SharePoint Installation
Notice that Report Server Configuration for SharePoint Integrated Mode includes two main parts, performed with two different tools:
This post presents the first part of Report Server Configuration for SharePoint Integrated Mode. This is the part you perform with Reporting Services Configuration tool.
The second part, performed in SharePoint Central Administration is available in:
Step 4 - Configuring Reporting Services for SharePoint 3.0 Integration - Part 2: Operations performed in SharePoint Central Administration (includes Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies Installation) (to be posted)
- Step 1: Start the Reporting Services Configuration tool and connect to the report server instance.
- Step 2: Configure a URL (Reporting Services Configuration).
- Step 3: Create a Report Server Database
- Step 4: Verify the part 1 of Reporting Services Configuration
2 - Click Reporting Services Configuration Manager
3 - In Server Name, specify the name of the computer on which the report server instance is installed. The name of the local computer appears by default, but you can type the name of a remote SQL Server instance if you want to connect to a report server that is installed on a remote computer. In our case, installation on a single machine we just have to let the default option.
4 - In Report Server Instance, select the SQL Server Reporting Services instance that you want to configure. Only SQL Server 2008 report server instances appear in the list. You cannot configure earlier versions of Reporting Services. In our case, default option can be used.
5 - Click Connect.
2 - On the Database page, click Change Database.
3 - Click Create a new database.
4 - Click Next.
5- Connect to the instance of the Database Engine that you will use to create and host the report server database:
For the current installation on a single machine we can keep default options
6 - Click Test Connection to validate the connection to the server.
7 - Click Next.
8 - Specify properties used to create the database.
The default option can be used, excepted the server mode
9 - Select SharePoint Integrated Mode.
10 - Click Next.
11 - Specify the credentials used by the report server to connect to the report server database.
Here also, default options are fine.
12 - Click Next.
13 - Review the information on the Summary page to verify the settings are correct.
14 - Click Next.
15 - wait while Report server Database Configuration Wizard configures report Server Database.
16 - Click Finish
Next figure shows the last page of Report Server database Configuration Wizard when configuration is complete.
1 - Click Web Service URL in the left menu.
2 - Look at default values.
- Verify that IIS (if it is installed) does not have virtual directory with the same name you plan to use.
- Verify that the Report Server Web Service URL is not already used especially by a SharePoint site.
3 - Click on Apply
Verify the connection by clicking the URL on the Report Server URL page.
If a Web Page is launched as shown in next figure, the part 1 of your Report Server Configuration for SharePoint Integrated Mode is done.