Instructor Blogs

AmeriTeach

« Free E-learning: What's New in Microsoft SQL Server 2008 | Main | SQL Server 2005 monitoring - Profiler and Trace »
Friday
Aug172007

SQL Server Reporting Services (SSRS) Installation/Configuration Guide for SharePoint Integration Mode

Well done! 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 MODE
You 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
SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments (2)

I've a problem installing Reporting Services Add-In for SharePoint integration on MOSS 2007 server.
It goes thru the install and ends with - The install was Interrupted.
Following errors are found:

1) EventViewer >> SQL database login failed. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

2) %Temp% Log >> SharePoint is installed, but not configured.

DBA says that the access to ANONYMOUS Logon cannot(should not) be given.

Can you please help / let me know that if any service(s) setting needs to be updated in my SharePoint server.

Or any other settings to be changed?
September 13, 2007 | Unregistered CommenterNitin
My friend, colleague and go-to guy for SSRS/Sharepoint issues, Ted Malone (http://portal.sqltrainer.com) suggested that this might indicate an issue with Kerberos authentication. Have a look at this KB article: http://support.microsoft.com/default.aspx/kb/832769
October 1, 2007 | Registered CommenterChris Randall

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.