SQL server reporting services can be configured in two modes

  • Native mode
  • SharePoint Integration mode

When reporting services are running in native mode, the reports will store on SQL server reporting server. When user sends a request for report the response comes from Report Server in SQL Server.

When reporting services running in SharePoint integration mode, SharePoint gets the reports from server via web service to end users.

Installation Instructions

SQL Server 2008 R2 Installation instructions to enable reporting services in SharePoint integration mode.

1. Select the SQL Server Feature Installation option from SQL Server 2008 R2 setup page

2. On the features selection page, Select Database Engine Services,Reporting Services then click Next

3. In Server Configuration page enter appropriate credentials and click Next

Note: SharePoint 2010 products in farm configuration require domain accounts     for service configurations.

4. On Reporting Services Configuration page, select Install SharePoint integrated mode default configuration and say finish.

Configuration steps on Report Server

After Setup is finished, you can verify that installation by connecting to the report server. You can test by browsing to /reportserver”>http://<your server name>/reportserver

1. Open the Reporting Services Configuration Manager from Configuration tools

image

2. Select the report server instance that you installed in SharePoint Integration mode

image

3. Configure the web service URL and test whether it is running fine or not. We are going to use this url in SharePoint Administration tool

image

4. Make sure your database is using SharePoint Integration Mode

image

Configuration Steps on SharePoint Server

1. Open the SharePoint Central Administration toll and the click General Application Settings

image

2. Click on Reporting Services Integration link under Reporting Services.

Enter the Reporting server web services URL that you configured earlier in the  Web Services URL box. Enter the authentication mode that you are using and credentials in the respective box then click ok

image

3. Upload the rdl files (SQL report files) to document library in SharePoint. If the configuration is successful then you should be able to see the SQL server Report in SharePoint 2010 as follows

image

 

resource