Click here to Skip to main content
14,690,772 members
Articles » Database » SQL Reporting Services » General
Technical Blog
Posted 17 Jun 2010

Tagged as

Stats

162.8K views
14 bookmarked

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

Rate me:
Please Sign up or sign in to vote.
4.67/5 (9 votes)
17 Jun 2010CPOL
Integrating Sharepoint 2010 and SQL Reporting Services 2008 in 6 easy steps

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.

Image 1

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:

Image 2

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

Image 3

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:

Image 4

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

Image 5

Review your configuration.

Image 6

Then wait while it's configured.

Image 7

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.

Image 8

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.

Image 9

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

Image 10

Once done, you will see the Activation State message.

Image 11

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.

Image 12

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.

Image 13

Image 14

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

Image 15

Now try to use the SQL Server Reporting Services Webpart:

Image 16

Image 17

Or you can also upload a report from a library.

Image 18

That's it, so simple!


Image 19 Image 20 Image 21 Image 22 Image 23 Image 24

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Raymund Macaalay
Technical Lead
New Zealand New Zealand
http://nz.linkedin.com/in/macaalay
http://macaalay.com/

Comments and Discussions

 
QuestionQuestion SSRS Pin
Ramez198821-Mar-12 12:53
MemberRamez198821-Mar-12 12:53 
QuestionAssuming location of physical instance of SSRS? Pin
cshiflett201116-Jan-12 9:41
Membercshiflett201116-Jan-12 9:41 
AnswerRe: Assuming location of physical instance of SSRS? Pin
Raymund Macaalay16-Jan-12 10:25
MemberRaymund Macaalay16-Jan-12 10:25 
QuestionRe: Assuming location of physical instance of SSRS? Pin
cshiflett201118-Jan-12 3:45
Membercshiflett201118-Jan-12 3:45 
AnswerRe: Assuming location of physical instance of SSRS? Pin
Raymund Macaalay18-Jan-12 14:59
MemberRaymund Macaalay18-Jan-12 14:59 
GeneralRe: Assuming location of physical instance of SSRS? Pin
Jonathan Manley10-Aug-12 9:55
MemberJonathan Manley10-Aug-12 9:55 
Question6 easy steps simply and clearly described Pin
glynrb3-Jan-12 9:13
Memberglynrb3-Jan-12 9:13 
Generalwhat's the point? Pin
Bruce Patin9-May-11 11:05
MemberBruce Patin9-May-11 11:05 
GeneralMy vote of 5 Pin
webooth2-Dec-10 5:25
Memberwebooth2-Dec-10 5:25 
GeneralThanks you Pin
Moustafa Arafa30-Jun-10 17:22
MemberMoustafa Arafa30-Jun-10 17:22 
GeneralRe: Thanks you Pin
Raymund Macaalay30-Jun-10 22:07
MemberRaymund Macaalay30-Jun-10 22:07 
GeneralSSRS2008 dont use IIS Pin
vahuja21-Jun-10 22:44
Membervahuja21-Jun-10 22:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.