Monday, August 27, 2018

SQL Server Reporting Services 2016 - Modes of Operation

The choices have not changed from previous versions. Your choice would depend on what you want to do. The resources needed will also influence your decision. For Example, the SharePoint mode would imply that you are running SharePoint Server or Services.

During SQL Server 2016 Installation you can choose to specify Reporting Services Configuration mode (review the screen shot).

There are two modes that you can specify Reporting Services Configuration:

Reporting Services Native Mode
Reporting Services SharePoint Integrated Mode

You can choose both modes or just one mode.

If you choose to install the Native mode there are two options:

Install and Configure
Install Only

Install and Configure option installs and configures the report server in Native Mode. However you need to do further configuration for your specific case. The Report Server is operaitonal with the Windows Service and the databases needed by Reporting Services in your named instance.

Install only installs the report server files. You need to use the RS Configuration Manager to compele configuration.

If you choose to install the SharePoint Integrated Mode you can only install the Report Server files but you will need SharePoint Central adminsitration to complete configuration.



Details for both modes of installation for SQL Server 2012 were described in my book:

ISBN 139781849689922
Paperback566 pages


No comments:

Post a Comment

SQL Server 2017 Performance Benchmarks

TPC is an acronym for Transaction Processing Corporation , a non-profit organization to define transaction processing benchmarks and prov...