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...

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...

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...

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...

Had multiple folks ask this question and there does not seem to be targeted docs as yet in this regard, hence decided to blog on this. Hope you find it helpful. If you need to in-place Upgrade to SharePoint 2010 then here are the recommended sequence...

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...

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...

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 ...

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...

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...

A] Forms Authentication If using SQL 2005 SP2 make sure you have installed the sharepointrs.msi that includes the following fix http://support.microsoft.com/kb/939942/ else move onto step2. Add the following entries to the Web.config file for...

I am aware and painfully so that a PG blog / site dedicated to SSRS integration with SharePoint has been long overdue. Hence, for my initial post I have compiled a short list of some unanswered questions I have seen from blogs / newgroups etc. on this...