Search this blog

Thursday, February 16, 2012

SSRS 2008 Command Line Utilities

Microsoft has provided following three utilities for managing the reporting server activities.
1.    RS.exe
2.    RSConfig.exe
3.    RSKeyMgmt.exe
These tools are more useful for configuring SSRS scale-out deployment, sharing encryption keys, managing SSRS objects like reports, data Source, etc.,

RS.exe
This utility helps to execute the VB.NET Scripts for automating the reports deployment. This tool support only when “Reporting services” not running in SharePoint Integrated Mode

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


Utility Location: <Drive:>\ Program Files\Microsoft SQL Server\100\Tools\Bin\rs.exe

RSConfig.exe
                                    
RSConfig utility helps to modify/manage the connection information of report services database

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


Utility Location: <Drive:>\ Program Files\Microsoft SQL Server\100\Tools\Bin\rsconfig.exe

RsKeymgmt.exe

This utility helps to manage the encryption key as well as it shares the encryption key to share with other Reporting services installation or instance.

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


Utility Location: <Drive:>\ Program Files\Microsoft SQL Server\100\Tools\Bin\rskeymgmt.exe

No comments:

Post a Comment