Configure SQL Reporting Services with WSS3.0 / MOSS 2007

Install SQL Server 2005 with Reporting Services
Install MOSS 2007
Install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies from
http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en



Report Server databases in SQL Server 2005

In IIS, We created a web site "RS" and an Application pool "RSAppPool"






On SQL Server:

Go to All Programs>Microsoft SQL Server 2005>Configuration Tools>Reporting Services Configuration

Select Machine name on which Reporting services are installed
Choose instance name & click on Connect

If Service Status is stopped click on Start button

Service status will change to running

Select website that we created "RS" & Click Ok

Report manager Virtual Directory Settings Click on New

Select website that we created "RS" & Click Ok

Enter password & click on button to browse a location for encryption file

Click Ok

Click Ok

Click on Apply

Click Ok

In Email Settings Enter Sender address & SMTP Server name

In Execution Account Check checkbox Specify an execution account
Enter Account and password

Click on Exit

On SharePoint Server:

1] Central Admin >Application Management>Reporting Services>Manage Integration Settings

Report Server Web Service URL = Enter :/reportserver">http://:/reportserver

Authentication Mode = Trusted Account

2] Central Admin >Application Management>Reporting Services>Grant Database Acces

Servername = Enter Report Server

In the pop up box enter credentials used for retrieving Reporting Services

Choose Default or Named Instance as applicable

Click Ok

3] Central Admin >Application Management>Reporting Services>Set Server Defaults

Above this step may error out

On Content Site>Site Actions>Edit Page>Add a webpart>Miscellaneous>

Select SQL Server Reporting Services Report Viewer & Click Add

Go to web part properties & configure Report Source