Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In
SharePoint By Bugday > Posts > How to: Integrate SharePoint 2010 and Reporting Services 2008 R2
February 09
How to: Integrate SharePoint 2010 and Reporting Services 2008 R2
by  Daniel Bugday  on 2/9/2011 9:31 AM

Here’s the steps to configure SharePoint 2010 with Reporting Services aka SSRS

Download the SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010 and install it on the Web-Front End Server.

How to: Install or Uninstall the Reporting Services Add-in

(You probably already have the Reporting Services Add-In installed for SharePoint so make sure that you check this in “Add/Remove Programs”, as the SP2010 prereq installer adds this add-in)

Now follow this steps to configure SSRS Config Manager:

1. “Start->Programs->Microsoft SQL Server 2008 R2->Configuration Tools->Reporting Service Configuration Manager”

    1. Click “Connect”
    2. Click “Web Service URL”
    3. Click the URL that is displayed for the web service url (ensure that the web service responds it may take a few seconds or a minute or two)

i. If promoted, type “Domain\administrator” with password “password”

    1. Click “Execution Account”
    2. Click “specify an execution account” checkbox
    3. For account type “Domain\Administrator”
    4. For password, type “password”
    5. Click “Apply”
    6. Close the Configuration Manager

2. Now you need to configure the Add-In using SharePoint Central Administration:

  1. Configure Reporting Services Add-in
    1. Open Central administration
    2. Click “General Application Settings”
    3. Click “Reporting Services Integration”
    4. For report server url, type http://URL/ReportServer
    5. For the auth mode, select “Windows Authentication”
    6. For username, type “Domain\Administrator”
    7. For password, type “password”
    8. Click “OK”
    9. Click “Close”
    10. Click “Set server defaults”, just ensure that the page loads without error

 

Figure after step 8:

image

Figure after step 10:

image

Your done!

Permanent Link to Post | Email Post Link | Number of Comments 11 Comment(s)

Comments

Integrate SharePoint 2010 and Reporting Services 2008 R2

Edit
Hello,

I follow the process but got an error while configuring Reporting Service Add in in SharePoint central admin.

The Messages i got in RED font are following


1) Warning: this page is not encrypted for secure communication. User names, passwords, and any other information will be sent in clear text. For more information, contact your administrator.
 
2) Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages


also when i tried to access the reporting server URL on SQL server 2008 R2 machine  and  its not working over there as well.

ERROR was:
Reporting Services Error
--------------------------------------------------------------------------------
 
The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpSecurity.set_StaticCatchAccessDeniedException(Boolean value) at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled) Get Online Help

--------------------------------------------------------------------------------
SQL Server Reporting Services



Please help...





Thanks
Ajay
 on 3/23/2011 5:41 PM

Integrate SharePoint 2010 and Reporting Services 2008 R2

Edit
Hello,

I follow the process but got an error while configuring Reporting Service Add in in SharePoint central admin.

The Messages i got in RED font are following


1) Warning: this page is not encrypted for secure communication. User names, passwords, and any other information will be sent in clear text. For more information, contact your administrator.
 
2) Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages


also when i tried to access the reporting server URL on SQL server 2008 R2 machine  and  its not working over there as well.

ERROR was:
Reporting Services Error
--------------------------------------------------------------------------------
 
The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpSecurity.set_StaticCatchAccessDeniedException(Boolean value) at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled) Get Online Help

--------------------------------------------------------------------------------
SQL Server Reporting Services



Please help...





Thanks
Ajay
 on 3/24/2011 12:14 PM

[Ajay] you might need to reinstall reporting services

Hi Ajay, make sure that reporting services got installed correctly and that you can access the reporting services web service before trying to integrate with sharepoint.

Make sure that the reporting service is started correctly using sql congifuration manager and using reporting configuration manager.

Cheers,
Daniel Bugday on 3/24/2011 2:12 PM

Adding reports to you document library from your desktop

Edit
For a fastest way to manage reports / data source with SharePoint, see this blog post : http://goo.gl/adEiy
 on 5/11/2011 6:26 AM

Thanks for sharing

Thanks
Daniel Bugday on 5/11/2011 4:36 PM

SSRS and sharepoint 2010 Two-Computer Deployment

Edit
Hello,
I Have the same problem like Ajay, I think the problem is that we are installing SSRS and sharepoint 2010 in two computer, can anyone help me to know how to perfetly install sharepoint 2010 and SSRS in multiple enviroment
Thank
 on 5/20/2011 4:22 PM

Install Reporting Services in Integrated mode MSDN

Hi, for a complete guide on how to setup and configure SharePoint and Reporting Services in a scaled out farm, please check this link:

http://msdn.microsoft.com/en-us/library/ee210649.aspx

Cheers,
Daniel Bugday
Daniel Bugday on 5/25/2011 2:14 PM

Reporting Service with SharePoint List

Edit
 on 8/22/2011 4:27 PM

Nick Lachey

Edit
Thanks for the post. Here’s a tool to use to create and publish your report online in minutes, without coding. You can create different graphs and layouts http://www.caspio.com/online-database/features/reports.aspx
 on 2/5/2012 9:25 PM

Error

Edit
The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpSecurity.set_StaticCatchAccessDeniedException(Boolean value) at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled) Get Online Help
 
 
 on 2/22/2013 7:41 PM
1 - 10Next

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


E-Mail *


TodayIs *


What's today's abbreviated value(DDD)

Attachments