Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Install SSRS as a feature or standalone? Expand / Collapse
Posted Sunday, July 28, 2013 1:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:48 AM
Points: 801, Visits: 502
Suppose you have a SQL installation with only the database engine configured
Some time later you need to install SSRS on the same box

Anyone know if there's a crucial difference between
- adding SSRS as an extra feature to the existing installation
- installing SSRS as a new installation next to the existing one

Maintenance maybe (updates, removal...)?
Post #1478336
Posted Sunday, July 28, 2013 1:50 PM



Group: General Forum Members
Last Login: Today @ 6:18 AM
Points: 15,396, Visits: 13,123
SSRS needs a SQL Server database, so installing it "as a new installation" means also installing SQL Server again as a seperate instance.
Personally I would add it as a new feature to the existing instance.

You only have to make sure that SSRS is patched to the same level. E.g. if SQL Server is updated with sp1, also run sp1 for SSRS.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1478401
Posted Monday, July 29, 2013 1:25 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:48 AM
Points: 801, Visits: 502
Hi Koen

thx for the reply.
Yes, SSRS needs a database but when selecting a "new" install, I can just as easily select only the Reporting Services component and then configure SSRS to create its databases on the SQL instance already installed. You don't need to select both the Reporting Services and Database Engine together. In fact, in most cases we install the Reporting Services component (without the engine) on a separate server (this means an extra license though) and use an existing clustered SQL instance to host the Reporting Services databases. This way we also have high availability (at least for the databases, later we can scale out the SSRS component if need be by adding more servers). It's also the preferred way because of security reasons (engine = backend, report server = frontend).

But some time ago a customer, already running a SQL instance for years, needed a Reporting Server. They asked to have its SSRS service running on that same host to avoid the extra license. When installing I just wondered what the difference is when adding SSRS to the existing installation as an extra feature/component as opposed to installing it as a new installation (so just selecting the SSRS component and then configure it to create its databases on the installation's database engine that was already present).

One difference that comes to mind is this: when you add SSRS as an extra component to an already existing db engine installation, you will end up with the same edition. Say for example you installed a SQL instance using Standard Edition, your added SSRS component will also be Standard Edition. If instead, in this scenario, you would like Enterprise edition for SSRS because of certain features, you have no other way than to upgrade the existing installation and add SSRS (before or after the upgrade) or to add SSRS as a new installation (Enterprise that be). In the last situation you would thus have a SQL Standard Edition database engine and a RS Enterprise Edition instance running on the same host (with the RS databases hosted in the Standard Edition's db engine).

I performed several tests in the past but I was wondering if someone encountered any critical issues with either approach. Something that doesn't make me regret my choice later.

Post #1478456
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse