Integrating Sharepoint 2010 and SQL Reporting Services 2008 in 6 easy steps

By | June 17, 2010

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 theres 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

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 exisiting, for this example we will create a new one

Connect to the database where you want your Report Data to be stored

Give it a Name and a Report Server Mode.
With Sharepoint Integrated Mode the report rdl’s are stored on SharePoint and not in the Report Database.  For this instance we will use the Sharepoint Integrated Mode

Specify the credentials that the report server will use to connect to the database.

Review your configuration.

Then wait while its configured.

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.

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.

Now populate the fields using the Web Service URL you had configured a while ago on Step 2 of this guide.

Once done you will see the Activation State message.

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.

At this point its 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 its now integrated, go to Site Settings on your Sharepoint Site then Site Collection Features.

Check if the Report Server Integration Feature is Active if not just click activate

Now try to use the SQL Server Reporting Services Webpart

Or you can also upload a report from a library.

Thats it, so simple!


10 thoughts on “Integrating Sharepoint 2010 and SQL Reporting Services 2008 in 6 easy steps

  1. tomas

    How can I configure sharepoint 2010 with reporting 2008 for internet access??

    Reply
  2. Pingback: Integrating Sharepoint 2010 and SQL Reporting Services 2008 in 6 easy steps | www.wiseinn.com

  3. John Pepper

    Hi Great article i have followed it exactly i have published a report via SSRS but when i go to browse to select my report it says there are no items in there

    Any idears

    Thanks again

    John

    Reply
  4. Michael T

    Hello, new to SSRS. Where is the configuration Manager found please?

    Reply
  5. 5 mistakes

    Your site is really cool to me and your topics are very relevant. I was browsing around and came across something you might find interesting. I was guilty of 3 of them with my sites. “99% of blog managers are guilty of these five errors”. http://is.gd/w4g8Ml You will be suprised how simple they are to fix.

    Reply
  6. prak_edv@lamilux.de

    Thanks for the article. I followed every single of your steps and can now upload .rdl files to a SP document library. But when i want to show the .rdl file i need to insert a username and a Password. I did that. Now the following Error message appears:

    rsProcessingAborted
    rsInvalidDataSourceCredentialSettingForITokenDataExtension

    I googeled those messages but didnt find anything.
    Can u help me ?

    Greetings
    Thomas S.

    Reply
  7. Inuka de Costha

    All the setps seems to be ok and finally when i try to add reporting service web part to a site page, im getting following error “a web part or web form control on this page cannot be displayed or imported. the type is not registered as safe”

    Reply

Leave a Reply