Few days back I was trying to install MOSS Add-In for SQL Server Reporting Services. The number of links below can show the problem that I have faced. Its very simple to install the add-in but configuration is not easy. Do read the installation and configuration guide before installing it on your server.
MOSS Add-in for Reporting Services Download (Important)
http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/SharePointRS.msi
Microsoft SQL Server Reporting Services – Installation and Configuration Guide for SharePoint Integration Mode (Important)
From looking at the comment stream for the "Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007" blog entry that was posted back in February, I can see that some people are still having difficulty installing and configuring SSRS in "SharePoint Integration Mode." Fortunately for you, Raju Sakthivel, an architect in the Microsoft Consulting Services group, has taken the time and effort to perfect and then document the whole process in the attached installation/configuration guide (3.5 MB in Word 2007 format). I hope that you will find it useful. Please leave a comment if you have any additional questions or issues.
SSRS and SharePoint make a powerful combination! If you have implemented an innovative or value add solution with the combo, please leave a comment with a description of what you’ve done.
Introduction to SQL Server Reporting Services
http://www.simple-talk.com/sql/sql-server-2005/business-intelligence-in-sql-server-2005,-part-1/
http://www.simple-talk.com/author/dejan-sarka/
SQL Server Recovery
http://blog.bpsnw.com/2007/09/my-steps-to-recovery.html
Report Builder and Forms Authenticaton in SQL Server Reporting Services 2005
http://blogs.msdn.com/bimusings/archive/2005/11/29/497848.aspx
Publishing Reporting Services reports to MOSS
Today! (Cleaning up Reporting Services SharePoint Add-In Setup Problems)
Direct Reports (Brian Welcker’s Weblog) : Reporting Services
http://blogs.msdn.com/bwelcker/rss_tag_Reporting+Services.xml
Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007
BI Whitepaper SQL Server Business Intelligence
Readme for Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies |
http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm
SQL Reporting Services, Cannot create a connection to data source login failed for user ‘null’
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21495110.html
Help with setting up Reporting Services
http://forums.asp.net/p/1061289/1530295.aspx
how can associated ‘sa’ with a trusted SQL Server connection in sql server 2005?
http://forums.asp.net/p/939856/1221882.aspx
how can associated ‘sa’ with a trusted SQL Server connection in sql server 2005?
Configuring Reporting Service Add-in for sharepoint – HTTP status 401: Unauthorized.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1379070&SiteID=1
Help!! "The report server has encountered a configuration error…….."
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=150192&SiteID=1
Report deployment error in SharePoint Integration mode
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1609891&SiteID=1
IIS 6 MMC problem with ReportServer and ASP.NET configuration
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250225&SiteID=1
Error "Connection Could not be made to the report server" when attempting deployment
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=335663&SiteID=1
Reporting Services and SharePoint 2007 install
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=588158&SiteID=1
Sharepoint integration – User cannot be found??
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1483741&SiteID=17
rsAccessDenied when accessing Report Server –
Cannot use ‘partitionResolver’ unless the mode is ‘StateServer’ or ‘SQLServer’ on server running SharePoint 2007
http://rfinn.spaces.live.com/blog/cns!4E19D0E183DFC38B!180.entry
You receive an "HTTP Error 401.1 – Unauthorized: Access is denied due to invalid credentials" error message when you try to access a Web site that is part of an IIS 6.0 application pool
http://support.microsoft.com/kb/871179
Error message when you try to modify or to delete an alternate access mapping in Windows SharePoint Services 3.0: "An update conflict has occurred, and you must re-try this action"
http://support.microsoft.com/kb/939308
How to use Trusted Connection when SQL server and web Server are on two separate machines.
http://weblogs.asp.net/achang/archive/2004/04/15/113866.aspx
Reporting Services Trouble Shooting SQL Server Books online
http://technet.microsoft.com/en-us/library/ms159704.aspx