SSRS and SharePoint Integrated Mode Installation Options

(Note: this is for SSRS 2008. Licensing has changed for SQL 2012. See here for details: https://mikesnotebook.wordpress.com/2012/06/22/ssrs-2012-licensing/)

The choice of native vs integrated mode is made during the config of the reporting services database. You can change at any point, but it means creating a new database (which means re-deploying all reports, etc). So the answer is really to decide up front, and stick with that. Here are your choices:

Scenario 0:

SQL01: SQL + SSRS in native (non-SharePoint) mode
No SharePoint server

In this scenario, users would use the SSRS site to view reports, or they could be embedded in asp.net pages.


Scenario 1:

SQL01: SQL + SSRS in native (non-SharePoint) mode
SP01: SharePoint WFE

In this scenario, SSRS is installed on a licensed copy of SQL, so there are no additional fees to run SSRS. Users would use the SSRS site OR the SharePoint site to view reports. (In a SharePoint site, you may add a web part that displays a report from the SQL01 using either the SSRS web part or a page viewer web part.)

In this scenario, there are no additional licensing fees for running SSRS.

Scenario 2:

SQL01: SQL + SSRS in integrated mode  + “minimal install” of SharePoint WFE
SP01: SharePoint WFE

 To run the above, SQL01 must have a “minimal install” of SharePoint in order to support SharePoint native mode. Which means that the sql box needs to be licensed for SharePoint. “minimal install” is a term that shows up in MS help docs for SSRS, but in actuality it means that the sql box needs to also be a SharePoint Web Front End (i.e. have iis and SharePoint installed and configured to be part of the farm). Users would use the SharePoint site to view reports.

Scenario 3:

SQL01: SQL
SP01: SharePoint WFE + SSRS in integrated mode

To run the above, SP01 would need a valid SQL license. Users would use the SharePoint site to view reports.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s