Click here to Skip to main content
Click here to Skip to main content

SQL Server Reporting Services in SharePoint mode or in Native mode

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

Introduction

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

http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb111.png

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.
  2. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb211.png

  3. Choose the Server Name and Reporting Services instance and click on Connect.
  4. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb34.png

  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.
  6. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb42.png

  7. Navigate to the Database tab and click on Change Database.
  8. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb51.png

  9. Choose to create a new report server database and click on Next.
  10. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb61.png

  11. Perform a connection test and if it succeeded continue and click on Next.
  12. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb71.png

    http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb81.png

  13. Choose the SharePoint integrated mode and click on Next.
  14. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb91.png

  15. Choose authentication type and your service credentials. Click on Next.
  16. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb101.png

  17. Verify the information in the summary screen and if everything seems fine click on Next.
  18. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb112.png

  19. Navigate to the Web Service URL tab and after configuring the Web Service Site information click on Apply.
  20. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb121.png

    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.
  22. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb131.png

  23. Click on Reporting Services Integration. 
  24. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb141.png

  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.
  26. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb151.png

    Once the process finishes you will get the following screen:

    http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb161.png

  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.
  29. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb171.png

  30. Provide the SSRS Service account credentials and click on OK.
  31. http://blog.cloudshare.com/wordpress/wp-content/uploads/2012/05/lb181.png

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

License

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

Share

About the Author

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

Comments and Discussions

 
QuestionProblem with SSRS Authentica​tion - don't want to use Custom Authentica​tion - Please guide PinmemberMember 1069685125-Mar-14 5:26 
GeneralMy vote of 4 Pinmemberpaul_cheung12-Jun-13 22:18 

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

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

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