-
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
- Upgrade Provisioning
- Report Distribution 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 |
| /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 |
| 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 |
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 |
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 |
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
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 |
|---|
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