Install Reporting Services at the Command Prompt
THIS TOPIC APPLIES TO: SQL Server Reporting Services (2016) SQL Server Reporting Services (2017) Power BI Report Server
Reporting Services supports a command-line installation from the SQL Server setup program. This topic contains several examples of command-line installations that are specific to Reporting Services. For a complete description of the command-line options available for all SQL Server components, see Install SQL Server from the Command Prompt. This topic does not describe command-line options for the Reporting Services add-in for SharePoint products. For information on command installation of the add-in, see Install the add-in using the installation file rsSharePoint.msi.
Native mode Reporting Services
RSINSTALLMODE (Native Mode)
The primary input setting for installing Reporting Services is the /RSINSTALLMODE input setting. The setting has two options: DefaultNativeMode and FilesOnlyMode
If the installation includes the SQL Server Database engine, the default RSINSTALLMODE is DefaultNativeMode.If the installation does not include the SQL Server Database engine, the default RSINSTALLMODE is FilesOnlyMode.If you choose DefaultNativeMode but the installation does not include the SQL Server Database engine, the installation automatically changes the RSINSTALLMODE to FilesOnlyMode. For more information on the input settings, see Install SQL Server 2016 from the Command Prompt.
Examples of Native Mode Installation
The following example installs the following and configures the accounts for :
Reporting Services in native mode.
The SQL Server Database Engine.
SQL Server Agent, which is needed for the Reporting Services subscriptions features.
SQL Server Management Studio.
Setup.exe /q /IACCEPTSQLSERVERLICENSETERMS /ACTION="install" /ERRORREPORTING=1 /UPDATEENABLED="False" /INSTANCENAME="MSSQLSERVER" /FEATURES="SQLEngine,Adv_SSMS,RS" /RSINSTALLMODE="DefaultNativeMode" /SQLSVCACCOUNT="[DOMAIN\ACCOUNT]" /SQLSVCPASSWORD="[PASSWORD]" /AGTSVCACCOUNT="[DOMAIN\ACCOUNT]" /AGTSVCPASSWORD="[PASSWORD]" /SQLSYSADMINACCOUNTS="[DOMAIN\ACCOUNT]"
SharePoint mode Reporting Services
RSSHPINSTALLMODE (SharePoint Mode)
The input setting to install Reporting Services in SharePoint mode is /RSSHPINSTALLMODE. The input setting has one option: SharePointFilesOnlyMode. The option installs all the files needed for SharePoint mode but, configuration is required following installation. The additional configuration steps are completed using SharePoint Central Administration. For more information, see Install The First Report Server in SharePoint Mode.
Examples of SharePoint Mode Installation
The following example installs SQL Server the database engine service and Reporting Services in SharePoint mode as well as the Reporting Services add-in for SharePoint (RS_SHPWFE).
setup /q /ACTION=install /FEATURES=SQL, RS_SHP, RS_SHPWFE,TOOLS /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
The following example installs only Reporting Services SharePoint mode.
Setup.exe /q /ACTION="Install" /IACCEPTSQLSERVERLICENSETERMS /FEATURES="RS_SHP" /INSTANCEDIR="C:\Program Files\Microsoft SQL Server" /INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" /INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" /INSTALLSQLDATADIR="C:\Program Files\Microsoft SQL Server" /SECURITYMODE="SQL" /SAPWD="[PASSWORD]" /PID="[Your PID Value]" /SQLSYSADMINACCOUNTS="[Account Name]" "AutoSql Admin Group" /ASSYSADMINACCOUNTS="[Account Name]" /UPDATEENABLED="False"
Examples of SharePoint Mode Upgrade
The following example upgrades Reporting Services SharePoint mode. RSUPGRADEPASSWORD is the password of the existing Report Server service account. RSUPGRADEPASSWORD is a required field in an upgrade scenario unless the Reporting Services service account is a built-in account.
Setup.exe /q /ACTION="Upgrade" /INSTANCENAME="MSSQLSERVER" /PID="[PID value]" /FTSVCACCOUNT="[DOMAIN\ACCOUNT]" /FTSVCPASSWORD="[PASSWORD]" /UPDATEENABLED="False" /IACCEPTSQLSERVERLICENSETERMS /RSUPGRADEPASSWORD="[PASSWORD]"
The following example can be used to upgrade a SharePoint Mode installation that is based on the SharePoint shared service architecture. The example uses switch ALLOWUPGRADEFORSSRSSHAREPOINTMODE. The switch is not needed for upgrading older versions that are not based on the shared service architecture:
SQL Server 2008 R2
SQL Server 2008
Setup.exe /q /ACTION="Upgrade" /INSTANCENAME="MSSQLSERVER" /PID="[Your PID Value]" /FTSVCACCOUNT="[ACCOUNT Name]" /FTSVCPASSWORD="[PASSWORD]" /UPDATEENABLED="False" /IACCEPTSQLSERVERLICENSETERMS /ALLOWUPGRADEFORSSRSSHAREPOINTMODE="True"
More questions? Try asking the Reporting Services forum