Home

SharePoint IT Pro Blog

MSDN Magazine Feed

Tuesday, July 1, 2008

SQL Server Reporting Services [SSRS] Installation- Configuration

The Sharepoint Team Blog has made an invaluable guide available documenting the process of installing SSRS in Sharepoint Integration mode. Get it here (download link - Word document, approx 3.5mb). This will help (immensely!) augment the information found at the team's earlier post, Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007
Some highlights from the document:
REQUIREMENTS FOR RUNNING REPORTING SERVICES IN SHAREPOINT INTEGRATED MODEYou can integrate Microsoft SQL Server 2005 Reporting Services with Windows SharePoint Services or Office SharePoint Server by configuring a report server to run in SharePoint integrated mode and by installing a Reporting Services Add-in that adds infrastructure and application pages to a SharePoint Web application.
The following versions and editions can be used to support integrated operations:
SQL Server 2005 Reporting Services with Service Pack 2. You cannot integrate a report server instance that is running earlier versions of the software. Supported editions include Evaluation, Standard, Developer, and Enterprise. There is no support for this feature in the Workgroup Edition or in SQL Server 2005 Express with Advanced Services.
Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. If you are using Office SharePoint Server , you must have the Office Server Premium or the Office Server Standard Edition.
Reporting Services Add-in for SharePoint Technologies. The add-in must be installed on the instance of the SharePoint technology you are using. There is only one version of the Reporting Services Add-in.
The document also provides links to the following resources:

Reference
SQL Server 2005 Books Online (May 2007)
SQL Server 2005 SP2

No comments: