Configure Reporting Services Instance - SQL-FineBuild/Common GitHub Wiki
| 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 |
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
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 |
|---|