Report Server Command Prompt Utilities

Report Server Command Prompt Utilities (SSRS)

 

Applies To: SQL Server 2016

SQL Server Reporting Services includes several command line utilities that you can use to administer a report server. These utilities are installed automatically when you install a report server.

NameCommand fileSupported Deployment modeDescription
RSS utilityrs.exeNative mode and SharePoint mode. The SQL Server 2008 R2 release introduced SharePoint mode support.The rs utility is a script host that you can use to perform scripted operations. Use this tool to run MicrosoftVisual Basic scripts that copy data between report server databases, publish reports, create items in a report server database, and more. To learn more about using scripts to administer a server, see Script Deployment and Administrative Tasks.
Powershell cmdletsSharePoint onlyFor a list of the of the powershell cmdlets, see PowerShell cmdlets for Reporting Services SharePoint Mode.
Rsconfig utilityrsconfig.exeNative onlyThe rsconfig utility is used to configure and manage a report server connection to the report server database. You can also use it to specify a user account to use for unattended report processing. For more information, see Reporting Services Report Server (Native Mode). To learn more about connection configuration, see Configure a Report Server Database Connection (SSRS Configuration Manager).
Rskeymgmt Utilityrskeymgmt.exeNative onlyThe rskeymgmt utility is an encryption key management tool. You can use it to back up, apply, recreate, and delete symmetric keys. You can also use this tool to attach a report server instance to a shared report server database. Rskeymgmt can be used in database recovery operations. You can reuse an existing database in a new installation by applying a back up copy of the symmetric key. If the keys cannot be recovered, this tool provides a way to delete encrypted content that you no longer use. To learn more about key management and storage of sensitive data, see Store Encrypted Report Server Data (SSRS Configuration Manager) and Configure and Manage Encryption Keys (SSRS Configuration Manager).
System_CAPS_ICON_note.jpg Note


If you prefer to use a tool that has a graphical user interface, you can use the Reporting Services Configuration manager instead of rsconfig and rskeymgmt.

Reporting Services Configuration Manager (Native Mode)
Reporting Services Tools
Reporting Services Report Server (Native Mode)

Community Additions

ADD
Show:
© 2016 Microsoft