Export (0) Print
Expand All

rsconfig Utility

SQL Server 2000

The rsconfig utility is used to specify configuration file settings in RSReportServer.config that use encrypted values. Configuration settings that use encrypted values include connection values used to connect to the report server database, and account values used for unattended report processing.

Rsconfig is used for two purposes: to modify the connection information that a report server uses to connect to a report server database, and to configure a special account that the report server uses to log on to a remote database server when other credentials are not available. For more information about either scenario, see Configuring a Report Server Connection or Configuring an Account for Unattended Report Processing.

The following table describes the combination of arguments to use, depending on the configuration settings you want to specify:

Argument Description
-c Use this argument to specify connection information used by the report server to connect to the report server database. Additional arguments provide values for settings you are configuring:

-m is used to specify a remote computer (optional)
-s is used to specify the Web server hosting the report server
-a is used to specify the authentication mode
-u and -p are used to specify an account
-d is used to specify the report server database name

-e Use this argument to configure an account used to support unattended report execution. The unattended account settings must include:

-u and -p are used to specify a domain user account. When used with the -e argument, the -u argument must include a domain name.

You can run Rsconfig on a local or remote instance of Reporting Services. You must be a local administrator on the computer that hosts the report server you are configuring. Windows Management Instrumentation (WMI) must be installed on the computer that you are configuring.

Important  If you run Rsconfig on a computer that is already running the Report Services Web service, you must reset Internet Information Services (IIS) to restart the Web service. You can reset IIS by typing iisreset at the command line.

File Location

The command line utilities are installed when you choose Administration Tools during Setup. You can run them from any directory on your file system. Rsconfig.exe is located at <drive>:\Program Files\Microsoft SQL Server\80\Tools\Binn.

Syntax
rsconfig {-?}
{–c } 
{–e } 
[–m computername]
[–s servername]
{–d databasename}
{–a authmethod} 
[-u username] 
[-p password]
[-t ]
Arguments

-?

Displays the syntax of rsconfig arguments.

-c

Used to set encrypted connection values in the rsreportserver.config file that connect a report server to the SQL Server instance hosting the report server database. This argument does not take a value. However, you must include additional arguments on the command line to specify that values that are encrypted in the configuration file. The arguments that you can specify include -m computername, -s servername, -d databasename, -a authmethod, -u username, -p password, and -t tracing. The following example illustrates the syntax for this argument:

rsconfig -c -s<yourservername> -dreportserver -aSQL -u<username> -p<password>

-e

Used to set encrypted credentials in the rsreportserver.config file for the unattended report execution account. This argument does not take a value. However, you must include additional arguments on the command line to specify that values that are encrypted in the configuration file. The arguments that you must specify include -u username and -p password. You can also set -t tracing. The remaining arguments (for example, -s or -a) have no effect when -e is specified on the command line. The following example illustrates the syntax for this argument:

rsconfig -e --u<domain>\<username> -p<password>

-m computername

(Required if you are configuring a remote computer.) Specifies the name of the computer on which the report server is installed. If this argument is omitted, the default is the computer on which Rsconfig.exe is running.

-s servername

(Optional if the SQL Server instance is local.) Specifies the default SQL Server instance that hosts the report server database. You cannot specify a named instance.

-d databasename

(Required if -c is specified.) Specifies the name of the report server database.

-a authmethod

(Required if -c is specified.) Specifies the authentication method that the report server uses to connect to the report server database. Allowable values are windows or sql. A value of windows specifies that the report server use Windows credentials when connecting to the report server database. A value of sql specifies that the report server use SQL Server credentials when connecting to the report server database.

-u [domain\]username

(Required when authmethod is set to sql or when -e is specified.) Specifies a user name. If you are setting credentials for the report server database and authmethod is set to windows, the report server impersonates a Windows user. In this case, you must provide a value for both domain and username in the format domain\username. This value is case-sensitive if you are using Windows Authentication.

-p password

(Required if -u is specified.) Specifies the password to use with the username argument. You can set this argument to a blank value if the account does not require a password.

-t

(Optional.) Adds trace information to any error messages that may occur. This argument does not take a value.

See Also

Configuring a Report Server Connection

Error Reporting for rsconfig Utility

Deploying and Administering Reporting Services

Reporting Services Configuration Files

Report Server Command Line Utilities

RSReportServer Configuration File

Show:
© 2014 Microsoft