Steps to configure the SQL Server Reporting Services to work with Sharepoint
A.
Download and install the Reporting Service Add-in for Sharepoint Technologies. User Sharepoint
Central Administration to configure report server integration. Specify a single report server URL and
set an authentication type on requests directed to the report server, grant database access to the
Report Server service account.
B.
Use the Change Database Wizard in the Dadabase page of Reporting Services Configuration
Manager to create the report server database in Sharepoint intergation mode
C.
Use Reporting services configuration manager to update the connection to the report server
database to allow Sharepoint intergration
D.
Use SQL server management studio to administer a report server database. Select features in
SharePoint Central Administration to allow report server
Explanation:
Resources: http://msdn.microsoft.com/en-us/library/bb326356.aspx
