My IT Experiences

Setting up Reporting Services for a SharePoint 2010 in integrated mode can be done in less than 30 minutes if you have the infrastructure ready. However there are a few things to take care of if we are in a SharePoint farm environment with different servers handling different roles. To get Reporting Services to work in SharePoint Integrated mode requires SharePoint object model. Either we install SharePoint object model on our database server running Reporting Service or install SQL Server Reporting Service on a SharePoint application server. Here are a few things to take care of: 1. Use a domain account in the Reporting Services Configuration Manager 2. In the Reporting Services Configuration Manager wizard, click on Apply in different screens before navigating away. 3. Reporting Services Add-in is required on SharePoint Servers; it is part of the SharePoint 2010 pre-requisite installer. It can also be downloaded and installed separately on SharePoint Servers.