High Level Steps:

  1. Setup two domain accounts for SSRS – one for the SSRS Windows Service and the other for the App Pool running the SSRS Web Services
  2. Install SQL Server 2008 with all required advanced services, Analysis, Integration and off course SSRS
  3. SSRS should be installed but not configured at install time
  4. Install WSS 3.0 SP2 or MOSS 2007 SP2
  5. Run Reporting Services Configuration Tool and choose Integration Mode when prompted
  6. Install Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies on all SP boxes starting with the one that hosts Central Administration Site
    1. http://www.microsoft.com/downloads/details.aspx?FamilyID=58edd0e4-255b-4361-bd1e-e530d5aab78f&displaylang=en

Make sure of the following things to avoid grief:

  • SharePoint Object Model is available on the SSRS installation box, not a problem if everything is on the same box but something to be careful of in a multi-server farm.
  • Remember Integrated mode only works for SharePoint Web Applications on the Default Zone and will not work with Web Apps with Anonymous access enabled
  • In Multiple Farm environments the copyappbincontent stsadm command must also be executed on each WFE
  • Make sure when using Kerberos, the DNS entry for the Web Application URL must be an A record, not CNAME