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…