Click here to Skip to main content
13,354,132 members (57,955 online)
Click here to Skip to main content
Add your own
alternative version


1 bookmarked
Posted 12 Jun 2013

SQL Server Reporting Services in SharePoint mode or in Native mode

, 12 Jun 2013
Rate this:
Please Sign up or sign in to vote.
SQL Server Reporting Services in SharePoint mode or in Native mode.


I installed SharePoint 2010 SP1 Enterprise Server and SQL Server 2008 R2.

Here are the steps to configure SSRS in a SharePoint Integrated mode.

  1. After the SSRS installation process finishes on your SQL Server, click on Start -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Reporting Services Configuration Manager.

  3. Choose the Server Name and Reporting Services instance and click on Connect.

  5. The following screen is important because it shows us the status of your SSRS server. When you finish your configuration process you can go back to this screen and see the Report Server mode will be set to a SharePoint Integrated mode.

  7. Navigate to the Database tab and click on Change Database.

  9. Choose to create a new report server database and click on Next.

  11. Perform a connection test and if it succeeded continue and click on Next.

  13. Choose the SharePoint integrated mode and click on Next.

  15. Choose authentication type and your service credentials. Click on Next.

  17. Verify the information in the summary screen and if everything seems fine click on Next.

  19. Navigate to the Web Service URL tab and after configuring the Web Service Site information click on Apply.

    If you haven’t created a site in SharePoint for SSRS yet, this is the time to create it.

  21. Navigate to the SharePoint 2010 Central Administration and click on General Application Settings.

  23. Click on Reporting Services Integration. 

  25. In the Report Server Web Service URL provide the URL. Choose an authentication mode and User credentials. Choose whether to activate the feature on all existing site collections or in specified site collection. Click on OK.

    Once the process finishes you will get the following screen:

  27. Navigate back to the General Application Settings screen choose the Add a Report Server to the Integration option.
  28. Provide the Server name and choose an instance.

  30. Provide the SSRS Service account credentials and click on OK.

Well done!! You have installed SSRS and can start using SharePoint’s features and enhancements for Reporting Services!


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


About the Author

Bhushan W. Juare
Software Developer (Senior)
India India
No Biography provided

You may also be interested in...


Comments and Discussions

QuestionPic Pin
B. Clay Shannon23-Feb-15 14:51
professionalB. Clay Shannon23-Feb-15 14:51 
QuestionRetrieve report service's status by code or sql query Pin
Shilpa_Soni19-Jan-15 0:12
memberShilpa_Soni19-Jan-15 0:12 
QuestionProblem with SSRS Authentica​tion - don't want to use Custom Authentica​tion - Please guide Pin
Member 1069685125-Mar-14 5:26
memberMember 1069685125-Mar-14 5:26 
GeneralMy vote of 4 Pin
paul_cheung12-Jun-13 22:18
memberpaul_cheung12-Jun-13 22:18 

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.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.180111.1 | Last Updated 12 Jun 2013
Article Copyright 2013 by Bhushan W. Juare
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid