Installing Reporting Services from the Command Prompt

SQL Server Setup

The Setup.exe program provides a command prompt interface in addition to the graphical Setup program. You can specify setup properties on the command line or in an .ini file to customize the way in which Setup.exe installs Reporting Services components or to suppress the user interface. To run Setup from the command line, you must be a local administrator on the system.

This topic describes the properties used to install Reporting Services components in a command line setup. It also provides examples of common installation scenarios. For more information about syntax and arguments used in a command line setup, see Running Setup from the Command Prompt and Specifying Setup Properties with an .ini File.

Command Line Examples for Reporting Services

The following examples illustrate the command line syntax and settings for common Reporting Services installation scenarios. In order for these examples to work, you must first navigate to the folder that contains the Setup.exe program. Example settings illustrate different ways of specifying a setup .ini file to achieve specific outcomes.

Basic syntax for a silent command line installation

Copy Code
Setup /settings c:\mysetup.ini /qn

Settings for installing Reporting Services components on a local computer

Copy Code
[Options]
INSTANCENAME=MSSQLSERVER
ADDLOCAL=SQL_Engine,SQL_Data_Files,RS_Server,RS_Web_Interface,SQL_WarehouseDevWorkbench,SQL_ComputerManagement,SQL_Workbench,RS_tools
SQLAUTOSTART=1
AGAUTOSTART=1
RSAUTOSTART=1
SECURITYMODE=SQL
SAPWD=<password>
PERPROCESSOR=2
RSCONFIGURATION=Default
RSSQLLOCAL=1

Settings for installing documentation and samples

Copy Code
[Options]
ADDLOCAL=SQL_Documentation,SQL_BooksOnline,SQL_SQLServerBooksOnline,SQL_Samples,SQL_AdventureWorksSamples,SQL_AdventureWorksDWSamples,SQL_ReportingServicesSamples

Properties for Reporting Services Components

When you install Reporting Service from the command line, you can specify the following properties. You can specify properties either on the command line or in an .ini file, but not both. If conflicting entries are provided, the entry on the command line is used.

RSACCOUNT="domain\logon_name"

Optional. Default value is the default built-in account for the current operating system. This property applies to the RS_Server feature selection. Specifies the account under which the Report Server Windows service runs. The domain name is limited to 254 characters, and the account name is limited to 20 characters. If a value is not supplied for RSACCOUNT, the following table shows the default built-in account selected.

Operating system Account

Windows 2000

Local System

Windows XP

Local System

Windows Server 2003

Domain User

RSPASSWORD="password"

Optional. Default value is null password. This property applies to the RS_Server feature selection. Specifies the password that corresponds to the user name specified for the RSACCOUNT property. The password is limited to 255 characters.

RSUPGRADEDATABASEACCOUNT="username"

Optional. Specifies a SQL Server database login used to connect to the SQL Server instance that hosts the report server database during an upgrade. The database user must have permission to modify the schema. It is useful to set this property if you are upgrading a report server that runs on a remote SQL Server instance. The database user name is limited to 20 characters.

RSUPGRADEPASSWORD="password"

Required if you specified the RSUPGRADEDATABASEACCOUNT. Specifies the password for the user account. An empty string is a valid value. The password is not stored or saved. The maximum length is 255 characters.

RSCONFIGURATION={ default | filesonly }

Optional. Specifies how a report server instance is installed. The default installation requires a local Database Engine instance and a system configuration that uses default values. The Database Engine instance cannot be installed as a virtual server.

The filesonly installation installs the program files and minimally configures a report server installation. Further configuration is necessary to make a report server operational. If this property is not specified, filesonly is used. For more information, see Default Configuration for a Report Server Installation and Report Server Installation Options.

RSAUTOSTART={ 1 | 0 }

Optional. Default value is true (1). This property applies to the RS_Server feature selection. Specifies whether the Report Server Windows service is started automatically when Windows is restarted. When the Report Server Windows service is registered with the operating system, the service startup type is set according to this value. Specify true (1) to start the service automatically or false (0) to set the startup type to manual.

ADDLOCAL = "feature_selection"

Specifies the features to be installed either for a new or existing installation. Features are specified as a comma-delimited list. When you install particular features, you must also specify certain properties for the installation to be successful. The following table lists each feature and any properties that are required.

The following table lists the properties available for each component. The feature selection column is the feature_selection parameter used with the ADDLOCAL or REMOVE properties when adding or removing components using the command prompt.

Component Feature selection value Available properties

Report Server Web service and Windows service, and Reporting Services Configuration tool

RS_Server

RSACCOUNT, RSPASSWORD, RSAUTOSTART, RSCONFIGURATION

Report Manager

RS_Web_Interface

None

Report Designer and Model Designer

SQL_WarehouseDevWorkbench

None

Reporting Services command line utilities

RS_Tools

None

Important:
When a prerequisite is missing, the associated component cannot be installed. If the affected component is specified on the command line in the ADDLOCAL property, setup terminates with an error.

See Also