Please note that this post applies to all the versions of the SharePoint and SSRS Integration: MOSS 2007 RTM/SharePoint 2010 RTM Native Mode Integration with the SSRS 2000 Sp2/SSRS 2005 RTM/SSRS 2008 RTM/SSRS 2008 R2 RTM using the SharePoint 2.0 Web Parts.
For more info, please visit this link: http://msdn.microsoft.com/en-us/library/ms159772.aspx
- There are two servers: Report Server – Windows OS and SSRS Pre-requisites installed, and SharePoint Server – WFE Servers in the Active MOSS 2007 Farm.
- This SharePoint SSRS Native Mode Integration Deployment Plan contains prepare, install/configure, and validation steps.
High Level Deployment Plan in Recommanded Order –
- Report Server – Prepare SSRS Install and Configuration Service Accounts
- Report Server – Install the SSRS using SQL Installation Disk with “Install but do not configure”
- Report Server – Configure SSRS through Reporing Services Configuration Manager in the Native Mode (Specify Report Web Service URL, Report Server Database, and other options like scaled out deployment)
- Report Server – Verify the Install and Config – IIS, DB, Services Snap-in
- SharePoint Server – Install RSWebParts.Cab file on the SharePoint WFEs (It will install the Report Viewer and Report Explorer web parts)
- Report Server – Install the SQL 2008 AdventureWorks DB, Verify Sample DBs are created
- Report Server – Install SQL 2008 Reporting Samples
- Report Server – Verify SSRS Samples in the BIDS 2008
- Report Server – Prepare Report Manger Web Site to host the reports – security, folders etc. Configure the Folders (Allow all domain users – NT AUTHORITY\Authenticated Users) in the Report Manager Web Site.
- Report Server – Optionally Configure the Report Manager System Settings for the Report Builder 2.0 (Supported only in the SSRS 2008 SP1)1
- Report Server – Deploy AdventureWorks Reports from the BIDS 2008 to the Report Manager Web Site
- Report Server – Verify SSRS Samples in the SSRS Report Manager Web Site
- SharePoint Server – Prepare SharePoint Envrionent – Web Part Pages to host the Report Viewer and Report Explorer web parts to view the SSRS Reports hosted on the Report Manager Site. Report Explorer web parts allows Report Builder access for Ad-hoc Reports.
- SharePoint Server – Validate the Reports are running fine from the SharePoint via web parts