Command Line Utilities in SSRS 2008

Although, in SSRS 2008, the Report Server configuration Manager configures the majority of settings, it is also possible to use command-line utilities. This can be useful for configuring SSRS 2008 scale-out deployments, sharing encryption keys and so on. The three main command lines are listed here, and this is then followed by details of the available parameters for each command.

RSConfig.exe

Configuration of connection properties between the Report Server to the repository database.

RSKeyMgmt.exe

Management of encryption keys via command-line

RS.exe

Scripting of report deployment

RSConfig Details

Here are the parameters for RSConfig.exe. Note that you will need to use quotation marks if any of the parameters e.g. database name contain a space:

Parameter

Description

/m

Remote server name; default is localhost

/i

Instance name, if a named instance is used

/c

Connection

/s

Database server name

/d

Database name

/a

Authentication method; either Windows or SQL authentication

/u

Username

/p

Password

/t

Trace log output goes to SSRS

/e

Unattended report execution; also needs /u and /p

RSKeyMgmt Details

Here are the parameters for RSKeyMgmt.exe:

Parameter

Description

/a

Restored and overwritten

/d

Deletes the key and encrypted data

/e

Extract key for backup to a file

/f

Filepath parameter for /a or /e parameter

/i

Named instance

/p

Password

/t

Trace log output goes to SSRS

/j

Adds a remote SSRS instance to the local Report Server database. /m (report server) and /n (instance name) are used with this parameter; /i refers to the local named instance

/r

Removes an SSRS instance from the scale-out deployment; use the GUID Installation ID to specify the instance

/u

Account name of the remote SSRS instance (optional)

/v

Password for the local admin of the remote SSRS instance (optional)

/m

Remote server name for /j

/n

Remote instance name for /j

RS Details

Here are the parameters for RS.exe, which is used for deploying reports:

Parameter

Description

/i

Input .rss file for execution

/s

URL to SSRS virtual directory

/u

Username

/p

Password

/l

Timeout in seconds; default is 60 seconds

/b

Batch command execution

/e

SOAP endpoint used; default is mgmt2005

/v

Global Variable mapping

/t

Trace log output goes to SSRS

To add this post to Twitter, please click here.

One thought on “Command Line Utilities in SSRS 2008

Leave a Reply