Export (0) Print
Expand All

Installing Reporting Services from the Command Line

SQL Server 2000

The Reporting Services setup.exe program provides a command prompt interface in addition to the graphical Setup program. Use the properties described in this section to customize the way in which Setup.exe installs Reporting Services components. You can:

  • Specify settings for these properties on the command prompt
  • Specify and save settings in an initialization (.ini) file that you specify with the /settings option.
  • Add or remove features to an installation of Reporting Services.
  • Remove Reporting Services.
  • Run an unattended installation.

Reporting Services Setup Command Line Syntax

The following syntax shows three setup command lines: the first one displays Help, the second one creates an installation, and the third one removes an installation.

Syntax

setup /?

setup
   [/i package_file | package_code]
   {/settings ini_file | property1=setting1 property2=setting2 ...}
   [{/qn}]
   [/l*v log_file]

setup /x package_code
   [/qn ]
   [/l*v log_file]

Arguments

Note  All parameters that contain a path require the use of a trailing backslash (\), as shown in the following example:

RSDATABASELOGFILELOCATION ="C:\Program Files\Microsoft SQL Server\"
Quotation marks are required only if an argument value contains a space.

/?

Displays the syntax for the setup arguments.

/i package_file | package_code

Specifies the name of the Windows installation package file (an .msi file) to be used to install Reporting Services. If the /i argument is not specified, or if package_file does not include a fully qualified path, ensure that the .msi file is in the same folder as setup.exe. To run setup in maintenance mode, use the /i argument with the package_file argument to specify the installation to be maintained, or use the /i argument with the package_code argument if the .msi file provided by Reporting Services was used for the installation.

In Reporting Services setup, there will be only one package file with multiple package codes so the package code must be specified

The package code is written to the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Reporting Services:ProductCode

/settings ini_file

Specifies the name of an .ini file that contains settings for the setup properties, which are listed later in this topic. If you use this argument, properties should be set in the .ini file, not on the setup command line. If you are performing an installation through the user interface while using the /settings argument, the user interface will be pre-populated with the data in the .ini file. If ini_file name does not include a fully qualified path, be sure to place the .ini file in the same folder as setup.exe.

property1=setting1 property2=setting2 ...

Sets a value for a setup property, which may have a string value or numeric value. You only need to include the property settings that are required for an installation. Spaces are permitted in a setting that contains character strings but the string must be enclosed in double quotation marks. If a double quotation character is included in the string, you must add an additional double-quotation character ("") as an escape code. For more information about setup properties and their values, see "Properties" later in this topic.

/x package_code

Specifies the Windows Installer installation package code to use when uninstalling Reporting Services. You must specify the package code of the installation package that was used to install Reporting Services. If package_code does not include a fully qualified path, be sure to place the .msi file in the same folder as setup.exe.

/qn

Specifies that setup runs unattended with no setup user interface.

/l*v log_file

Specifies the name and path to a verbose log file containing all Windows Installer log options. If you do not specify this argument, no log file is created.

Properties

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.

INSTALLDIR="Reporting_Services_executable_folder_path"

Specifies the folder in which the Reporting Services executable files are installed. The default path is %system drive%:\Program Files\Microsoft SQL Server.

USERNAME="user_name"

Specifies the user name for the user who is registering the product.

COMPANYNAME="company_name"

Specifies the name of the company for which the product is registered.

REINSTALL=All

Specifies that Setup or Windows Installer install all previously installed Reporting Services features. The only value supported is All.

REINSTALLMODE={ omus | amus }

Specifies the level of processing performed by Setup or Windows Installer. Specify REINSTALLMODE=omus when resuming a failed setup attempt. With this option, the entire installation process is verified and completed. This option reinstalls all files, shortcuts, and icons that are missing or that are from an older version, and rewrites registry entries.

REINSTALLMODE=amus when files have become corrupted, such as after a failure of the disk drive that holds the Reporting Services components. This option reinstalls all files, shortcuts, and icons regardless of version, and rewrites registry entries

The following table describes the meaning of each letter in the omus and amus property value.

Code Option
o Reinstall if file is missing or if an older version is present.
a Reinstall all files, regardless of checksum or version.
m Rewrite all required registry entries from the Registry table that go to the HKEY_LOCAL_MACHINE or HKEY_CLASSES_ROOT registry hive. Rewrite all information from the Class table, Verb table, PublishComponent table, ProgID table, MIME table, Icon table, Extension table, and AppID table. Reinstall all qualified components.
u Rewrite all required registry entries from the Registry table that go to the HKEY_CURRENT_USER or HKEY_USERS registry hive.
s Reinstall all shortcuts and re-cache all icons, overwriting any existing shortcuts and icons.

PERSEAT="per_seat_license"

Specifies the number of per seat licenses purchased. Note that the PERSEAT or PERPROCESSOR property can be used, but not both.

PERPROCESSOR="per_processor_license"

Specifies the number of per processor licenses purchased. Note that the PERSEAT or PERPROCESSOR property can be used, but not both.

PIDKEY=cdkey

Required. Specifies the 25-character product identification key that is required for installation.

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 ReportServer 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 Network Service

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.

RSAUTOSTART={ 1 | 0 }

Optional. Default value is true (1).

This property applies to the RS_Server feature selection.

Specifies whether the ReportServer service is started automatically when Windows is restarted. When the ReportServer service is registered with the operating system, the service's startup type is set according to this value. Specify true (1) to enable the service to start automatically or false (0) to disable the service from starting automatically.

RSVIRTUALDIRECTORYSERVER="virtualdirectory"

Optional. Default value is ReportServer.

This property applies to the RS_Server feature selection.

Specifies the virtual directory for the report server. The path given in the virtualdirectory portion of the argument is relative to the server URL. Setup creates an IIS virtual directory under the default web site with the name specified, and points to the <install directory>\Reporting Services\ReportServer folder. The virtual directory name is limited to 50 characters, and the characters used in the name must comply with IIS naming conventions. The following table shows the characters that are not valid in virtual directory names.

Character Character
\ (backslash) " (quotation mark)
/ (slash mark) < > (angles brackets)
: (colon) | (vertical bar)
* (asterisk) ; (semicolon)
? (question mark) @ (at sign)
= (equal symbol) & (ampersand)
+ (plus sign) $ (dollar sign)
{ } (braces) ^ (circumflex)
[ ] (brackets) ` (accent grave)
, (comma) . (period)

RSVIRTUALDIRECTORYMANAGER ="virtualdirectory"

Optional. Default value is Reports.

This property applies to the RS_Manager feature selection.

Specifies the virtual directory for Report Manager. Setup creates an IIS virtual directory with the name specified, and points to the <install directory>\Reporting Services\ReportManager folder. The path given in the virtualdirectory portion of the argument is relative to the server URL.

RSDATABASESERVER="servername\instancename"

Optional. Default value is the default instance of SQL Server on the local machine.

This property applies to the RS_Server feature selection.

Specifies the SQL Server instance that hosts the report server database. All editions of Reporting Services require SQL Server 2000 with SP3a or later. For Standard Edition, the instance of SQL Server must be local. For all others, it can either be local or available over the network. The servername portion of the parameter can be a hostname, or an IP address. Reporting Services does not support MSDE as a SQL Server instance.

RSDATABASENAME = "ReportServerDatabase"

Optional. Default value is ReportServer.

This property applies to the RS_Server feature selection.

Specifies the name of the report server database that the report server will use to store its metadata. If the database does not exist, it is created. If the database name entered in this property already exists, it is assumed that a web farm installation is being done. Setup checks the edition and version of the product. If the product is Standard, which does not support web farms, or the version is an incorrect version, an error occurs and a new name must given. If the edition supports web farms, the existing database is used, and the report server is activated as part of the web farm. Note that when an existing database is used, the RSWEBFARMSERVER property must also be specified.

The RSDATABASENAME name must contain a minimum of 1 character, and not exceed the maximum length of 117 characters. The name must be generated according to the following rules.

  • The first character must be a letter, as defined by the Unicode Standard 2.0, or an underscore "_" character. The characters "@" and "#" are not allowed as the starting characters of a database name, as these characters have special meaning in SQL.
  • The second and subsequent characters can be any letter, as defined by the Unicode Standard 2.0, or decimal numbers from either Basic Latin or other national scripts, or the "@", "$", "#", or "_". Note that a Transact-SQL reserved words are not allowed as an identifier, whether created in uppercase or lowercase as SQL Server reserves both versions of the reserved words.
  • Embedded spaces or special characters are not allowed.

RSDATABASEDATAFILELOCATION="database_file_location"

Optional. Default location is the location where the SQL Server instance exists that is hosting the report server database.

This property applies to the RS_Server feature selection.

Specifies the folder where the report server database data file is stored. The folder must exist and be on the same computer that hosts the SQL Server instance that is hosting the report server database. This option is ignored when using an existing report server database.

RSDATABASELOGFILELOCATION = "database_logfile_location"

Optional. Default location is the location where the SQL Server instance exists that is hosting the report server database.

This property applies to the RS_Server feature selection.

Specifies the folder where the report server database log files are stored. The folder must exist and be on the same computer that hosts the SQL Server instance that is hosting the report server database. This property is ignored when using an existing report server database.

RSSETUPACCOUNT="logon_name"

Optional. Default value is the credentials of the user running Setup to connect to the server.

This property applies to the RS_Server feature selection.

Specifies the SQL Server logon that is used by Setup to connect and create databases on the instance of SQL Server specified in the RSDATABASESERVER property.

The account must be an administrator, and have permission to perform the following tasks:

  • Create logins
  • Create roles
  • Create databases
  • Assign permissions to users

RSSETUPPASSWORD="password"

Optional if RSSETUPACCOUNT is not specified. Default value is null.

This property applies to the RS_Server feature selection.

Specifies the password for SQL Server logon credentials specified in RSSETUPACCOUNT. This property is required if RSSETUPACCOUNT is specified.

RSSQLACCOUNT="domain\logon_name"

Optional. Default login is the account used by RSACCOUNT.

This property applies to the RS_Server feature selection.

Specifies the user account that the report server uses to connect to the report server database at run time. The domain name is limited to 254 characters, and the account name is limited to 20 characters. If the RSSQLACCOUNT is a SQL login, you must specify a RSDATABASESECURITY MODE of "SQL" as RSDATABASESECURITY defaults to a Windows login.

The account is granted public and RSExecRole roles for the report server database, and the RSExecRole role for the master, msdb and ReportServertempDB databases. The account can be either a Windows account or a SQL Server login. When a Windows account is specified, the account is added as a login user to the database server specified in RSDATABASESERVER. When an SQL Server account is specified, the SQL account is created on the database server that is specified in the RSDATABASESERVER if it does not already exist, and is granted login permissions.

RSSQLPASSWORD="password"

Optional if RSSQLACCOUNT is not specified. Default value must be supplied if RSSQLACCOUNT is specified, and cannot be blank.

This property applies to the RS_Server feature selection.

Specifies the password for the SQL Server credentials specified in RSSQLACCOUNT. The password is limited to 255 characters. This is a required property when RSSQLACCOUNT is specified, unless RSSQLACCOUNT is an operating system built-in account. When RSSQLACCOUNT is a built-in account, then RSSQLPASSWORD is ignored. Setup does not create the account specified in RSSQLACCOUNT when a blank password is specified in RSSQLPASSWORD.

RSDATABASESECURITYMODE="SQL"

Optional. If not supplied, RSSQLACCOUNT is assumed to be a Windows user account.

This property applies to the RS_Server feature selection.

Specifies that the account specified in RSSQLACCOUNT is a SQL Server logon account, not a Windows account. When RSDATABASESECURITYMODE is specified, the value must be "SQL".

RSEMAILSMPTSERVER="servername"

Optional. No default value.

This property applies to the RS_Server feature selection.

Specifies the SMTP server that is used to deliver reports. The servername can be a hostname, or an IP address.

RSEMAILFROM="from@ext.com"

Optional. No default value.

This property applies to the RS_Server feature selection.

Specifies the e-mail address that appears in the From line a report is delivered through e-mail.

RSREDIRECTTOMANAGER = {0|1}

Optional. Default value is false (0).

This property applies to the RS_Manager feature selection.

Specifies that Setup will add redirection from the top-level Web site to the Report Manager virtual directory.

RSUSESSL = {0|1}

Optional. Default is false (0).

This property applies to the RS_Server feature selection.

Specifies whether the report server requires Secure Sockets Layer (SSL) connections when communicating sensitive data. If you set this value to false (0), SSL is not used. If you set this value to true (1), the SSL security level is set to 2, which means that most APIs require SSL. For more information about the APIs that require SSL, see Using Secure Web Service Methods.

Important  Deployment fails if SSL is set to true (1) during setup, but an SSL certificate is not installed on the computer.

RSSAMPLESFILELOC = "path"

Optional. Default is the Reporting Services installation directory.

This property applies to the RS_Samples feature selection.

Specifies the path where the samples are installed.

RSSAMPLESDATABASESERVER =
"servername\instance"

Optional. Default location is the value specified in RSDATABASESERVER. If RSDATABASESERVER is not specified, the default location is the default instance on the local machine.

This property applies to the RS_AdventureWorks feature selection.

Specifies the SQL Server instance where the sample database is installed, and it must be an instance on the local machine. The servername portion of the parameter can be a hostname, or an IP address. You cannot install the sample database in a SQL Server instance other than the one into which the report server is being installed.

RSWEBFARMSERVER = servername\instancename

Optional. No default value.

This property applies to the RS_Server feature selection.

Specifies the computer which is running the report server installation that uses the existing report server database. The servername portion of the parameter can be a hostname, or an IP address. The RSWEBFARMSERVER does not have a default value if not explicitly specified. A valid database must be given in RSDATABASENAME and exist on the server given in RSDATABASESERVER. If the edition of Reporting Services being installed does not support web farms, Setup returns an error.

RSWEBFARMACCOUNT = "domain\username"

Optional. Default account is the context of the user running Setup.

Specifies the Windows account that has permission to administer computer that was specified in the RSWEBFARMSERVER property.

RSWEBFARMPASSWORD = "password"

Optional. Default value is null.

This property applies to the RS_Server feature selection.

Specifies the password for the username specified in the RSWEBFARMACCOUNT property.

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 RS_Server RSACCOUNT,
RSPASSWORD,
RSAUTOSTART,
RSVIRTUALDIRECTORYSERVER,
RSDATABASESERVER,
RSDATABASENAME,
RSDATABASEFILELOCATION,
RSDATABASELOGFILELOCATION,
RSSETUPACCOUNT,
RSSETUPPASSWORD,
RSSQLACCOUNT,
RSSQLPASSWORD,
RSEMAILSMPTSERVER,
RSEMAILFROM,
RSDATABASESECURITYMODE,
RSUSESSL,
RSWEBFARMSERVER,
RSWEBFARMACCOUNT,
RSWEBFARMPASSWORD
Report Manager RS_Manager RSVIRTUALDIRECTORYMANAGER,
RSREDIRECTTOMANAGER
Report Designer RS_Designer None
Administration tools RS_Admin_Tools None
Product documentation RS_BooksOnline_<language> None
Sample reports,
sample applications
RS_Samples RSSAMPLESFILELOC
AdventureWorks OLTP database RS_AdventureWorks RSSAMPLESDATABASESERVER

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.

Note  Be sure to specify RSDATABASELOGFILELOCATION and RSDATABASEFILELOCATION in the same setup operation. If you specify RSDATABASELOGFILELOCATION by itself, a setup error will occur.

Note  When running an unattended setup on a Windows 2000 server, specifying a domain user account for the RSACCOUNT requires that you specify a SQL Server login for RSSQLACCOUNT. Otherwise, you will get an activation error at the end of setup.

REMOVE = "feature_selection"
Specifies the features to be removed. The feature-selection list can contain installed features, where the features are the same as those for ADDLOCAL. The feature-selection list should be comma-delimited. The list of feature_selection values is shown in the ADDLOCAL property.

Specifying Setup Command Prompt Properties with an .ini File

Optionally, you can specify setup command prompt properties using an .ini file. On the setup command line, use the /settings ini_file argument to specify the .ini file. The first line in the .ini file must contain the string [Options]. An outline of an .ini file, Template.ini, is included with the product. It is not installed when Reporting Services is installed. However, you can find it on the product CD-ROM or the location of where you installed Reporting Services from, and copy it to your local machine for modification. The Template.ini file on the SQL Server 2000 Reporting Services installation CD-ROM provides detailed instructions for creating an .ini file and contains a template with parameters that you can fill in. Find the parameters that are not commented, and then provide the appropriate value for each parameter. The following example illustrates the format of the .ini file and shows the use of some of the Reporting Services arguments:

[Options]
USERNAME=MyName
COMPANYNAME=MyCompany
INSTALLDIR="C:\Program Files\Microsoft SQL Server\"
RSAUTOSTART=1
RSVIRTUALDIRECTORYSERVER=ReportServer
RSEMAILFROM="myEmail@hotmail.com"
...
See Also

Installing Reporting Services

Show:
© 2014 Microsoft