SQL RS Parameters - SQL-FineBuild/Common GitHub Wiki
| 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.
Index
The parameters are divided into the following sections:
- Basic Install
- Account Provisioning
- Alias Provisioning
- Cluster Provisioning
- RS Configuration Provisioning
- Upgrade Provisioning
- Report Distribution Provisioning
Basic Install
| 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 |
| /RSName: | /Server: Report Server | Discription to show on Report Manager Home Page |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /CatalogServer: | (none) | Server/Instance name that holds the Reporting Services Catalog |
| /RSSvcStartupType: | Automatic | (SQL2008 and above) SQL Report Service startup type |
| /RSAutoStart: | 1 | (SQL2005 only) SQL Report Service startup type |
| /RSConfiguration: | (none) | (SQL2005 only) Mode of installation for Report Services |
| /RSInstallMode: | (none) | (SQL2008 to SQL2016) Mode of installation for Report Services |
| /RSSQLLocal: | 1 | (SQL2005 Only) Indicates the Report Server databases are on the same server as Reporting Services |
| /TCPPortRS: | 80 | TCP Port for Reporting Services |
Account Provisioning
| Parameter | Default | Comment |
|---|---|---|
| /RsSvcAccount: | (SqlSvcAccount) | Service Account for Report Service |
| /RsSvcPassword: | (SqlSvcPassword) | Password for Report Service Account |
Alias Provisioning
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 |
Cluster Provisioning
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 |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /ClusterNameRS: | (calculated) | Name of Report Services Cluster |
| /ClusRSIPSuffix: | (calculated) | TCP final octet for RS Cluster address |
| /ClusRSSuffix: | RS | Suffix added to Windows Cluster Name to form the Report Services Cluster Name |
Report Distribution Provisioning
This section shows the parameters you can add to the Basic Install to set up report distribution options 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 |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /RsShareAccount: | (RsExecAccount) | Name of Report Server Delivery Share Account |
| /RsSharePassword: | (RsExecPassword) | Password for Report Server Delivery Share Account |
RS Configuration Provisioning
This section shows the parameters you can add to the Basic Install to configure a Report Server.
| Parameter | Default | Comment |
|---|---|---|
| /SetupRSAdmin: | Yes | Configure RS Administration Accounts |
| /SetupRSKeepAlive: | No | Set to YES to install RS Keep Alive job |
| /SetupRSIndexes: | (none) | Configure additional Indexes to improve RS performance |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /SetHeaderLength: | 65334 | Set maximum report URL length (bytes) |
| /SetWorkingSetMaximum: | (calculated) | Set maximum RS Working Set size (KB) |
Note: /SetWorkingSetMaximum: If no value is given then this is calculated as the lower of 8GiB or 10% of server memory
Upgrade Provisioning
This section shows the parameters you can add to the Basic Install when upgrading from a previous version of Report Service
| Parameter | Default | Comment |
|---|---|---|
| /RSUpgradeDatabaseAccount: | (none) | Database Owner account for RS Upgrade |
| /RSUpgradePassword: | (none) | Password for Database Owner account for RS Upgrade |
Copyright FineBuild Team © 2021. License and Acknowledgements
| Previous SQL AS Parameters | Top | SQL IS Parameters Next |
|---|