Deployment and Administration Tools

Deployment and Administration Tools

SQL Server 2000

You can use the following tools and technologies to deploy and manage reports, components, and applications.

Report Deployment Tools

To deploy a report, you publish it to a report server. After a report is published, you can use a browser or Report Manager to make reports available for viewing. You can use the following tools to publish and view reports.

Tool Use
Report Designer Report Designer provides several approaches for publishing report definitions to a report server. For more information, see Testing Reports and Deploying Reports to a Production Environment.
Report Manager Report Manager is a Web-based application that you can use to view reports. You can run Report Manager on a production server to provide end-user access to reports that you deploy. For more information, see Viewing Reports with Report Manager.

You can also use Report Manager to upload a Report Definition Language (.rdl) file to a report server. For more information, see Uploading Files to a Folder.

Browser You can use a browser connection to view reports that you have published to a report server. For more information, see Viewing Reports with a Browser.

Component Deployment Tools

You can use the following tools and applications to deploy and manage components.

Tool Description
Setup You can use Setup to install individual components or a combination of components. You can also use Setup to install a Web farm. Setup creates the report server database, establishes default security, configures Internet Information Services (IIS) for the report server and Report Manager, and specifies the Microsoft Windows® accounts that the services run under. For more information, see Installing Reporting Services.
Enterprise Manager and Query Analyzer You can use Enterprise Manager to back up, restore, and replicate a report server database, or to define a SQL Server login to use for the connection between the report server and the report server database. You can use Query Analyzer to run Transact-SQL commands against the report server database. For more information, see Administering a Report Server Database.
Internet Information Services You can use IIS to modify security on the virtual directories used to access the report server and Report Manager. For more information, see Configuring Web Host Security for a Report Server.
Report Manager You can use Report Manager to set application security through the role-based authorization model, specify report execution time-outs, enable selected features, and set limits that control report processing. For more information, see Report Manager and Managing and Working With Published Reports.
rs utility You can use rs.exe to run scripts on a report server. You can use scripts to copy content between report server databases, publish reports, and more. For more information, see Scripting Deployment and Administrative Tasks and rs Utility.
rsactivate utility You can use rsactivate.exe to activate a report server in a Web farm or recover from a hardware failure. For more information, see Activating a Report Server Instance and rsactivate Utility.
rsconfig utility You can use rsconfig.exe to modify the connection string and credentials that are used to authenticate a report server connection. For more information, see Configuring a Report Server Connection and rsconfig Utility.
rskeymgmt utility You can use rskeymgmt.exe to back up encryption keys used by the report server. For more information, see Managing Encryption Keys and rskeymgmt Utility.
Text editor You can use a text editor to view and modify settings in configuration files. For more information, see Reporting Services Configuration Files
Microsoft Application Center Application Center is a Web application deployment and management tool from Microsoft. Microsoft recommends that you use Application Center to deploy and manage a report server Web farm. For more information about Application Center, go to the Application Center Web site.

Application Deployment Tools

Reporting Services does not include application deployment tools. You must use the tools and technologies available through your application development environment to deploy custom applications.

If you are building custom extensions, you can read topics in Books Online to find out about deployment requirements. For more information, see Deploying a Delivery Extension and Deploying a Data Processing Extension.

See Also

Deploying and Administering Reporting Services Components

Report Server Command Line Utilities

Browser Types Supported by Reporting Services

Reporting Services Component Overview

© 2016 Microsoft