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.
Can you please show me how to call the command line prompts…