-
Notifications
You must be signed in to change notification settings - Fork 10
SQL RS Parameters
| Previous SQL AS Parameters | SQL IS Parameters Next |
|---|
The parameters that are useful for a Report Service Install are given below. SQL FineBuild can install both SQL Reporting Services and PowerBI Report Server. The parameters cover both the basic install and the provisioning that can be performed by SQL FineBuild.
If you are happy that the default value for a given parameter is right for your organisation then you do not need to provide that parameter.
When you run SQL FineBuild you should always provide a /AdminPassword: parameter giving your own password in order to log on automatically after a reboot.
The parameters are divided into the following sections:
- Basic Install
- Account Provisioning
- Alias Provisioning
- Cluster Provisioning
- RS Configuration Provisioning
- Unattended Execution Provisioning
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLRS: | (none) | Set to YES to install Report Service |
| /SetupPowerBI: | (none) Set to YES to install PowerBI Server in place of SQL Reporting Services | |
| /TCPPortRS: | 80 | TCP Port for Reporting Services |
| /RSName: | /Server: Report Server | Discription to show on Report Manager Home Page |
| Parameter | Default | Comment |
|---|---|---|
| /RsSvcAccount: | (SqlSvcAccount) | Service Account for Report Service |
| /RsSvcPassword: | (SqlSvcPassword) | Password for Report Service Account |
This section show the parameters needed to set up a DNS Alias to Report Services, to provide Connection String Stability for end users
| Parameter | Default | Comment |
|---|---|---|
| /SetupRSAlias: | No | Set up RS DNS Alias |
| /RSAlias: | (none) | Name of RS DNS Alias |
This section shows the parameters you can add to the Basic Install in order to install a SQL Server Cluster. These parameters are only valid if you are installing on to a Windows Cluster.
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLRSCluster: | No | Set to YES to install a Report Service Cluster |
This section shows the parameters you can add to the Basic Install to configure a Report Server.
| Parameter | Default | Comment |
|---|---|---|
| /SetupRSKeepAlive: | No | Set to YES to install RS Keep Alive job |
| /SetHeaderLength: | 65335 | Set maximum report URL length (bytes) |
| /SetWorkingSetMaximum: | (none) | Set maximum RS Working Set size (bytes) |
This section shows the parameters you can add to the Basic Install to set up unattended report execution for use with scheduled reports .
| Parameter | Default | Comment |
|---|---|---|
| /SetupRSExec: | No | Set to YES to setup Unattended Report Execution |
| /RsEmail: | (none) | Sending Email Address for scheduld reports configured to be emailed |
| /RsExecAccount: | (none) | Name of account to be used for unattended report execution |
| /RsExecPassword: | (none) | Password for unattended execution account |
Copyright FineBuild Team © 2021. License and Acknowledgements
| Previous SQL AS Parameters | Top | SQL IS Parameters Next |
|---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP