SSRS 2008 integration with sharepoint

In Simple, if you want to integrate SSRS 2008 with Sharepoint, follow the steps:

1. Download and install Reporting services Addin (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=200fd7b5-db7c-4b8c-a7dc-5efee6e19005) to sharepoint Web Front End server (WFE) in simple on machine where sharepoint is installed

2. Activate a site collection-scoped feature called Report Server Integration Feature on the Central Administration site.
This feature has two different behaviors when gets activated on Central administration site than other sites. When activated on the Central administration site , the feature does all of the things it does for other type of sites , plus it adds a section called Reporting Services under the Application Management. This section must be used to make sure SharePoint is aware of my SSRS instance existence

3.Configure Reporting Services
- Go to Central administration site -> application management
There are three options in this section:

• Grant Database Access: First you need to specify the server which hosts reporting services database, whether it is on a default or named instances. Essentially what happens here is that the Report Server endpoint and Windows service accounts for that instance (named or default) will be granted required access to the SharePoint databases. During this process, the Report Server service will be restarted. This is an essential step in integration.
• Manage integration settings : You need to specify Report server URL and the authentication. Pretty straightforward.
• Set Server Defaults :You set all of your basic defaults. This page contains all of the things you’d normally use Reporting Services Configuration tool to configure them, but they are now managed via SharePoint tier. For example making sure that all data sources use integrated security, so on and so forth. Ad-hoc reporting is also a powerful feature which can be set and controlled from here.

Once configuration completes.. then comes adding of content types..

4. Once you activate the feature , the following things will be added to your site collection:

I.Required content types:

• Report builder model
• Report builder report
• Report builder Data Source

II.Report viewer web part in Web part gallery

III. A section in the Site Settings for managing shared schedules

Obviously if you want to be able to store your reports in a Report Library and your data sources in Data Connection Library , you need to enable another web-scoped “Office SharePoint Server Enterprise Site features” feature to get Report Library and Data Connection Library in the create page. This has nothing to do with SSRS Add-in though !

That’s all about it! I hope this blog post can help you verify your SSRS 2008 installation in integration mode.