Integrating SSRS 2008 R2 RTM with SharePoint 2007

The SSRS 2008 R2 Report Server in SharePoint mode allows integrating with SharePoint 2007:  

• Supported configuration: SSRS 2008 R2 is supported on SharePoint 2007 with the SSRS 2008 RS Add-in for SharePoint version SP2 onwards. This can now be downloaded from : https://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en. Additionally, details on SP2 can be found @ https://blogs.technet.com/b/dataplatforminsider/archive/2010/09/29/sql-server-2008-sp2-is-available-for-download-today.aspx 
  (outdated information: The timeline for SP2 is no earlier than Sept. 2010, having said that you can consider trying out the functionality / this configuration using the latest SSRS 2008 SP2 CTP version of this Add-in available @ https://www.microsoft.com/downloads/details.aspx?FamilyID=65606fdd-093f-4c70-91f6-dc1f24520e8f&displaylang=en )
• Features available:   In this configuration features available include Alternate Access Mapping, SharePoint List Reporting extension in connected mode, Report Builder 3.0 with Report Parts, ATOM Renderer, RS.EXE enabled to script against SharePoint mode, etc.
• Features not available: Key features not avilable include Out-of-the-box (OOTB) Local mode reporting, AJAX ReportViewer, ULS logging, etc. 

For details on features supported by SSRS 2008 R2 Report Server with SharePoint 2007 refer to https://msdn.microsoft.com/en-us/library/bb326290(v=SQL.105).aspx

HTH,
Prash

Comments

• Anonymous
  June 02, 2010
  i have a question does ssrs 2008 r2 work for sharepoint 2007.

• Anonymous
  June 08, 2010
  The comment has been removed

• Anonymous
  June 16, 2010
  Hi Mike, did you find a solution of your problem? I'm having the same, but no answer found on the network! Thanks Davide

• Anonymous
  June 16, 2010
  No I have not heard a follow-up to this item yet.  I'd really like to know as soon as possible so if you hear anything please let me know. Thanks Mike

• Anonymous
  June 16, 2010
  No I have not heard a follow-up to this item yet.  I'd really like to know as soon as possible so if you hear anything please let me know. Thanks Mike

• Anonymous
  July 14, 2010
  Guys, I had this question with MS when they were lunching 2008 R2, so as per MS, production type release will be available on Sep 2010. Meanwhile you can try to install on your development and staging server but can't use on production until production type install available. Its sad that we are not able to use SSRS 2008 r2 adds Ins. There is no alternative way.

• Anonymous
  September 13, 2010
  Hi Prash, We are waiting to migrated to SSRS 2008 R2 integrated with SharePoint. Does RTM for SSRS 2008 R2 add-in for SP 2007 is still scheduled to be released in Sep? Any fixed date yet? Thanks, Surabhi.

• Anonymous
  September 28, 2010
  Sorry for the delay and combining answers:

• SSRS 2008 R2 Report Server supports SharePoint 2007, however you will need the updated SSRS 2008 SP2 RS Add-in for SharePoint for this.
• Sorry, but I do not have an exact /specific public release date for SP2, having said that it is not expected to be very far / long. HTH Prash

• Anonymous
  October 05, 2010
  Has the SSRS 2008 SP2 RS Add-in for SharePoint 2007 been released?

• Anonymous
  October 06, 2010
  Yes. It can be downloaded @ www.microsoft.com/.../details.aspx HTH Prash

• Anonymous
  October 10, 2010
  After installing the SSRS 2008 SP2 RS Add-in for sharepoint 2007, do i have to do some special settings on AAM to enable Multiple Zones support.

• Anonymous
  May 10, 2011
  For a fastest way to manager reports / data source with SharePoint, see this blog post : http://goo.gl/adEiy

• Anonymous
  September 07, 2011
  Hi, I'm using reporting services in SharePoint 2007 but there is an issue when the report is generated. Below is the error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'CustomWebServiceDS'. (rsErrorOpeningConnection) Keyword not supported: 'http://websrv1/2011/_vti_bin/report.asmx;integrated security'.

• Anonymous
  September 15, 2011
  Does it work with Sharepoint WSS 3 SP2 64bit on Windows Server 2008 and SQL Server 2008 R2 Standard? Thanks!

• Anonymous
  February 06, 2013
  I am experiencing the same problem with SQL Server 2008 R2 SP2 and SharePoint 2010. We are running the Reporting Services Add-in for Microsoft SharePoint Technologies 2010. Most of my searching keeps bringing up this article: social.msdn.microsoft.com/.../92671fe5-ce6d-472b-b6e1-48c62f556c51 but it also refers to MOSS 2007 so I am hoping to find a resolution to the same issue but with SharePoint 2010. Any info is appreciated!