I do not see the SSRS Shared Service in SharePoint CA after installing SSRS "Denali" CTP SharePoint mode

After successfully installing the latest SSRS “Denali” CTP SharePoint mode Service and SSRS “Denali” Add-in for SharePoint 2010, if you do not see “SQL Server Reporting Services”  in the Service or Service Application list: SharePoint 2010 Central Admin -> “Application Management” -> “Manage Services on Server” OR SharePoint 2010 Central Admin -> “Application Management” -> “Manages Service Applications”…


Performance of SSRS in SharePoint mode reports in full-page view in SharePoint 2010.

Using SSRS in SharePoint mode version 2008 R2 or earlier full-page report rendering is slower than its corresponding Native mode. This is largely due to SSRS in SharePoint mode comprises Native mode functionality and additional calls to the SharePoint object model APIs for SharePoint integration specific operations. Additionally, for some reports with short Native mode rendering times especially those…


Migrating SSRS 2008 R2 SharePoint mode from one SharePoint Farm to another

In general, master copies of SSRS Content types items like Reports (.rdl), data sources (.rsds), semantic models (.smdl) etc. are stored in the SharePoint content DB and cached on-demand by SSRS in the RS catalog. Additionally, report / data source metadata like subscriptions, schedules, snapshots, stored credentials etc. are exclusively stored in the RS catalog….


Configuring Kerberos Authentication for SSRS 2008 R2 with SharePoint 2010.

A new whitepaper is being released today on “Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products“. Scenario #4 comprises specifics on setting this up with SQL Reporting Services entailing – dependencies, checklist, step-by-step instructions etc. Hope you find this whitepaper and Scenario #4 helpful. Looking forward to your feeedback on this. Happy Kerberos configuration in RS…


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 : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en. Additionally, details on SP2 can be found @ http://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…


Integrating SSRS 2008 R2 RTM with SharePoint 2010 RTM

The SSRS 2008 R2 release in SharePoint mode allows two forms of reporting: Out-of-the-box (OOTB) Local mode reporting: In this case, SSRS 2008 R2 introduces the ability to render reports without an integrated Report server. Details on local mode reporting with SharePoint integration can be found @ http://msdn.microsoft.com/en-us/library/ff487969(v=SQL.105).aspx. From an install prespective you only need to install…


Error installing rsSharePoint.msi on Windows 2008

When installing the rsSharePoint.msi on Windows 2008 you need to ensure you run it with “Run As Administrator”. Having said that, in multi-machine scenarios you may run into an error along the lines “Insufficient SQL database permissions for user ‘SYSTEM’ in database Sharepoint_AdminContent_<guid>….”. The root cause, is on Windows 2008 or higher version OS’s rsSharePoint.msi run its…


Integrating SSRS with SharePoint 2010 Beta 1 / Beta 2

Warning: Recommended version of Report Server for use with SharePoint 2010 Beta1 is SSRS 2008 R2 CTP2 / CTP3 only. The only version of SSRS Add-in for SharePoint with SharePoint 2010 Beta 2 is SSRS 2008 R2 November CTP Add-in. Using SSRS 2008 with Beta product – MOSS Beta 1 or Beta 2 is expected to work, however it is not…


Passing URL report parameters to Reports in SharePoint Document Library in SSRS 2008 & R2

Passing URL report parameters directly to a report in a SharePoint Document Library is enabled in the SQL Server Reporting Services 2008 Integration with SharePoint Add-in. Why? Key intent is to allow specifying non-default report parameter values when rendering of a report in full-page view in SharePoint.   How do you use this feature? Simply add-on the URL report…