Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode

In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took (see How to: Install and Configure SharePoint Integration on a Stand-alone Server):

  1. Install SQL Server 2008 and on the on the Feature Selection page select the Database Engine Services as well as Reporting Services
  2. During the install, when you get to the on the Reporting Services Configuration page, choose “Install the SharePoint integrated mode default configuration”
  3. When the SQL Server 2008 installation is finished, run the SharePoint 2010 Products Preparation tool to install the Microsoft SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint Technologies 2010, or you could instead install it separately via this download
  4. Install SharePoint 2010
  5. Run the SharePoint Products Configuration Wizard, choosing the database engine you installed in step #1
  6. Configure the report server integration features via the SharePoint Central Administration.  Do this by going to the Manage Service Applications screen, click New, and choose “SQL Server Reporting Services Service Application”

In SQL Server 2012, this has been changed.  When installing SQL Server 2012, on the Feature Selection page, as before you choose Database Engine Services, but now on this page is the option to choose “Reporting Services – SharePoint”, so step #2 above it not needed (this is also an option to choose “Reporting Services – Native”).  This is also an option called “Reporting Services Add-in for SharePoint Products”, so step #3 above is not needed either.  Note that the “Reporting Services Add-in for SharePoint Products” is a newer version than what is installed with the SharePoint 2010 Products Preparation tool, with one of the new features it installs being Power View.  Steps #4-6 are the same.


Leave a comment on the original post [, opens in a new window]

Loading comments...