Configure Reporting Services Instance

Previous Install SSIS Raw File Reader	Install Report Service Next

SQL FineBuild can configure a Report Services Instance. This includes configuration needed to use Kerberos security and items needed to govern Report Server resource usage.

The Instance can either be a traditional SQL Server Reporting Services (SSRS) instance or a PowerBI Report Server (PBIRS) instance. The instance can be clustered or non-clustered.

Report Services Configuration Tasks

There are multiple tasks needed to configure a Report Services Instance:

Item	Comment
Install Report Service	Either SSRS or Power BI Server can be installed
Setup Report Service file permissions	Set file permissions not included with Microsoft Installer
Setup Report Service Database	Create RS database where not done by Microsoft Installer
Setup RS Service Account permissions	Set account permissions not included with Microsoft Installere
Setup RS Roles in SQL System Databases	Needed for Cluster Install
Build additional RS DB Indexes	Improve performance of RS
Connect Report Services to the database	Needed for Cluster Install
Setup RS Virtual Folders	Set virtual folders where not included with Microsoft Installer
Setup HTTP Reservation Security	Needed when RS uses a Domain Service Account
Backup Report Service Encryption Keys	Backup encryption keys used by Report Services
Setup Report Service Administration Accounts	Setup Administration Accounts for Report Services
Setup Report Service Unattended Execution Account	Account used to run Scheduled Reports
Setup RS Email Account	Account used to send Reports via Email
Setup RS File Share Account	Account used to store Report output on File Share
Setup RS Resource Options	Set important RS Resource Use parameters
Connect RS Instance to RS Farm	Needed for Cluster Install
Connect RS Instance to Cluster	Needed for Cluster Install
Setup Report Service IIS Alias	Configure IIS Alias for Report Services
Setup RS Service Dependency	Set service startup dependency to ensure SQL DB starts first
Setup RS IE Compatibility	Allow IE Compatibility Mode for Reports
Configure Report Services Keep Alive	Configure job to keep Report Servicees running

Top

FineBuild Configure Report Services Instance

The Report server Instance Processing relates to Process Ids 2BB and 4RA and is controlled by the parameters below:

SQL Version	Parameter	FULL Build	WORKSTATION Build	CLIENT Build
SQL2019	/SetupSQLRS:	Yes	Yes	N/A
SQL2017	/SetupSQLRS:	Yes	Yes	N/A
SQL2016	/SetupSQLRS:	Yes	Yes	N/A
SQL2014	/SetupSQLRS:	Yes	Yes	N/A
SQL2012	/SetupSQLRS:	Yes	Yes	N/A
SQL2008R2	/SetupSQLRS:	Yes	Yes	N/A
SQL2008	/SetupSQLRS:	Yes	Yes	N/A
SQL2005	/SetupSQLRS:	Yes	Yes	N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter /InstSQLRS: can also be used.

FineBuild also uses the following parameters to help configure Report Services Instance:

Parameter	Default Value	Description
/SetupPowerBI:	see text	Setup PowerBI in place of SSRS. Default is YES for SQL2017 and above, NO for all other situations.
/SetupSQLRSCluster:	see text	Default is YES if Windows is clustered, N/A for all other situations
/SetupRSIndexes:	YES	Setup additional indexes on RS DB to improve performance
/SetupRSAdmin:	YES	Set DBA Groups as RS Administrators
/SetupRSExec:	YES	Setup RS Unattended Execution Account
/RSExecAccount:		Name of RS Unattended Execution Account
/RSExecPassword:		Password for RS Unattended Execution Account
/SetupRSAlias:	NO	Configure Alias for RS Instance
/RSAlias:		Name of DNS Alias for RS Instance
/PowerBIPID:		PID for PowerBI Report Server
/ClusterNameSQLRS:		Name of RS Cluster
/RSAccount:		Name of RS Service Account
/RSPassword:		Password for RS Service Account
/MailServer:		Name of Mail Server
/RSEmail:		Name of RS Email Account
/RSShareAccount:		Name of RS File Share Account
/RSSharePassword:		Password for RS File Share Account
/RSHeaderLength:	65534	Maximum length of RS Report URL
/RSMaximumWorkingSet:	8000000	Maximum memory allowed to be used by RS (Default 8 GB)
/ClusterIPV4RS:		IP v4 address for RS Cluster
/ClusterIPV6RS:		IP v6 address for RS Cluster

FineBuild will automatically perform all the tasks listed in Report Services Configuration Tasks

Top

Installing Report Services with Express Edition

Report Services can be installed for all SQL Server Editions apart from some versions of Express Edition:

Express Edition Version	Installable
SQL Server 2005, all Express Editions	No
Express Edition Basic	No
Express Edition with Tools	No
Express Edition Advanced	Yes
Express Edition Advanced with Tools	Yes

Copyright FineBuild Team © 2013 - 2021. License and Acknowledgements

Previous Install SSIS Raw File Reader	Top	Install Report Service Next