Configure Reporting Services Instance

Previous Configure Notification Services Instance	Configure Standard Accounts 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 Services	Either SSRS or PBIRS can be installed
Setup Report Services file permissions	Not all permissions are set at install time
Setup RS Service Account permissions	Not all permissions are set at install time
Confgure the Report Services database	Needed for Cluster Install
Setup RS Roles in SQL System Databases	Needed for Cluster Install
Configure Report Services URLs	URLs include Cluster name and RS Alias name
Setup HTTP Reservation Security	Needed when RS uses a Domain Service Account
Build additional RS DB Indexes	Improve performance of RS
Connect Report Services to the database	Needed for Cluster Install
Setup RS Encryption Key	Save RS Encryption Key in a standard location
Setup DBA Groups as RS Administrators	Replace Windows Administrators with DBA Groups as RS Administrators
Setup RS Unattended Report 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 IIS Alias for RS	Allow RS to be accessed via a DNS Alias
Setup RS IE Compatibility	Allow IE Compatibility Mode for Reports
Configure Reporting 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 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:	20000000	Maximum memory allowed to be used by RS (Default 20 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]

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

Top

Copyright FineBuild Team © 2013 - 2019. License and Acknowledgements

Previous Configure Notification Services Instance	Top	Configure Standard Accounts Next