There are only 6 main steps to achieve this task assuming you already have an instance of SQL Server Reporting Services and SharePoint 2010.
I had created this starting from a clean installation of SQL Reporting Services so this guide will discuss the steps on configuring your SQL Reporting Services 2008 for integration with SharePoint 2010.
Step 1: Configuring SQL Reporting Services – Web Service URL
Simply go to Reporting Services Configuration Manager and choose Web Service URL and populate the following needed information. The fields are named properly so I guess there is no need for further explanation. What this does is that it configures the IIS for you depending on what Virtual Directory names you had declared.
![Reporting Services Configuration 1](https://anyrest.files.wordpress.com/2010/06/reporting-services-configuration-1.jpg?w=630&h=456)
Step 2: Configuring SQL Reporting Services – Create a Report Database
Same here, fields need no further explanation except for one which is Native Mode and SharePoint Integrated mode which I will explain below.
Choose create a database or if you already have one choose an existing one. For this example, we will create a new one:
![Reporting Services Configuration 2](https://anyrest.files.wordpress.com/2010/06/reporting-services-configuration-2.jpg?w=630&h=453)
Connect to the database where you want your Report Data to be stored:
![Reporting Services Configuration 3](https://anyrest.files.wordpress.com/2010/06/reporting-services-configuration-3.jpg?w=630&h=452)
Give it a Name and a Report Server Mode.
With SharePoint Integrated Mode the report RDLs are stored on SharePoint and not in the Report Database. For this instance, we will use the SharePoint Integrated Mode:
![Reporting Services Configuration 4](https://anyrest.files.wordpress.com/2010/06/reporting-services-configuration-4.jpg?w=630&h=453)
Specify the credentials that the report server will use to connect to the database.
![Reporting Services Configuration 5](https://anyrest.files.wordpress.com/2010/06/reporting-services-configuration-5.jpg?w=630&h=451)
Review your configuration.
![Reporting Services Configuration 6](https://anyrest.files.wordpress.com/2010/06/reporting-services-configuration-6.jpg?w=630&h=452)
Then wait while it's configured.
![Reporting Services Configuration 7](https://anyrest.files.wordpress.com/2010/06/reporting-services-configuration-7.jpg?w=630&h=451)
Step 3: Configuring SQL Reporting Services – Create a Report Manager URL
What this does is that it configures the IIS for you depending on what Virtual Directory names you had declared.
![Reporting Services Configuration 8](https://anyrest.files.wordpress.com/2010/06/reporting-services-configuration-8.jpg?w=630&h=458)
That’s it. At this point, your report server is configured for SharePoint Integration 2010.
Step 4: SharePoint Integration Configuration – Reporting Services Integration
Simply go to SharePoint 2010 Central Administration, then General Application Settings, then choose Reporting Services Integration.
![SharePoint Integration Configuration 1](https://anyrest.files.wordpress.com/2010/06/sharepoint-integration-configuration-1.jpg?w=630&h=318)
Now populate the fields using the Web Service URL you had configured a while ago on Step 2 of this guide.
![SharePoint Integration Configuration 2](https://anyrest.files.wordpress.com/2010/06/sharepoint-integration-configuration-2.jpg?w=630&h=536)
Once done, you will see the Activation State message.
![SharePoint Integration Configuration 3](https://anyrest.files.wordpress.com/2010/06/sharepoint-integration-configuration-3.jpg?w=630&h=537)
Step 5: SharePoint Integration Configuration – Add a Report Server to the Integration
Now add the report server by putting the Server Name and the Server instance.
![SharePoint Integration Configuration 4](https://anyrest.files.wordpress.com/2010/06/sharepoint-integration-configuration-4.jpg?w=630&h=392)
At this point it's all done, all you have to do now is try it out.
Step 6: Verify by Checking the Server and Uploading a Report
To verify if it's now integrated, go to Site Settings on your SharePoint Site, then Site Collection Features.
![Verify 0a](https://anyrest.files.wordpress.com/2010/06/verify-0a.jpg?w=258&h=419)
![Verify 0b](https://anyrest.files.wordpress.com/2010/06/verify-0b.jpg?w=308&h=147)
Check if the Report Server Integration Feature is Active, if not just click activate:
![Verify 1](https://anyrest.files.wordpress.com/2010/06/verify-1.jpg?w=630&h=374)
Now try to use the SQL Server Reporting Services Webpart:
![Verify 2](https://anyrest.files.wordpress.com/2010/06/verify-2.jpg?w=630&h=250)
![Verify 3](https://anyrest.files.wordpress.com/2010/06/verify-3.jpg?w=629&h=468)
Or you can also upload a report from a library.
![Verify 4](https://anyrest.files.wordpress.com/2010/06/verify-4.jpg?w=630&h=382)
That's it, so simple!