Skip to content

install-reporting-services-at-the-command-prompt.md

Latest commit

 

History

History
86 lines (57 loc) · 7.14 KB

install-reporting-services-at-the-command-prompt.md

File metadata and controls

86 lines (57 loc) · 7.14 KB
title Install Reporting Services 2016 at the Command Prompt - SSRS | Microsoft Docs
ms.date 01/09/2018
ms.prod reporting-services
ms.prod_service reporting-services-native
ms.topic conceptual
helpviewer_keywords
command line
ms.assetid 048169b3-512c-41e4-895a-0416eff41268
author maggiesMSFT
ms.author maggies
monikerRange = sql-server-2016 || = sqlallproducts-allversions

Install Reporting Services 2016 at the Command Prompt

[!INCLUDEssrs-appliesto] [!INCLUDEssrs-appliesto-2016] [!INCLUDEssrs-appliesto-not-2017] [!INCLUDEssrs-appliesto-not-pbirsi]

[!INCLUDEssRSnoversion] supports a command-line installation from the SQL Server setup program. This topic contains several examples of command-line installations that are specific to [!INCLUDEssRSnoversion]. 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 [!INCLUDEssRSnoversion] 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 [!INCLUDEssRSnoversion] 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 from the Command Prompt.

Examples of Native Mode Installation

The following example installs the following and configures the accounts for :

Setup.exe /q /IACCEPTSQLSERVERLICENSETERMS /ACTION="/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/reporting-services/install-windows/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 [!INCLUDEssRSnoversion] 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 [!INCLUDEssRSnoversion] in SharePoint mode as well as the [!INCLUDEssRSnoversion] add-in for SharePoint (RS_SHPWFE).

setup /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/reporting-services/install-windows/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 [!INCLUDEssRSnoversion] SharePoint mode.

Setup.exe /q /ACTION="/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/reporting-services/install-windows/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 [!INCLUDEssRSnoversion] SharePoint mode. RSUPGRADEPASSWORD is the password of the existing Report Server service account. RSUPGRADEPASSWORD is a required field in an upgrade scenario unless the [!INCLUDEssRSnoversion] service account is a built-in account.

Setup.exe /q /ACTION="/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/reporting-services/install-windows/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:

Setup.exe /q /ACTION="/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/reporting-services/install-windows/Upgrade" /INSTANCENAME="MSSQLSERVER" /PID="[Your PID Value]" /FTSVCACCOUNT="[ACCOUNT Name]" /FTSVCPASSWORD="[PASSWORD]" /UPDATEENABLED="False" /IACCEPTSQLSERVERLICENSETERMS /ALLOWUPGRADEFORSSRSSHAREPOINTMODE="True"

Next steps

Install SQL Server from the Command Prompt
SysPrep Parameters
Install Power Pivot from the Command Prompt

More questions? Try asking the Reporting Services forum