Selecting Components of Reporting Services to Install
Reporting Services consists of server-side and client-side components that can be installed together or separately. You can use Setup to install all components on a single computer. You can also run Setup more than once to install a specific component, such as Report Designer, on a different computer.
When a prerequisite for a component is missing, the component cannot be installed. If you are installing Reporting Services using Setup, the component is omitted from the Feature Selection page. When you install Reporting Services from the command prompt, if any such components are specified in the ADDLOCAL property, Setup terminates with an error. The components have different hardware and software requirements. For more information on the hardware requirements, see Hardware Requirements for Reporting Services. For more information on the software requirements, see Software Requirements for Reporting Services.
The following server components are included with Reporting Services.
Important Report server and the SQL Server instance hosting the report server database must be in the same domain or in a trusted domain.
Report Server and Report Manager
The report server is a stateless server that stores the meta data and object definitions in a report server database. The report server is implemented as a Microsoft Windows® service and as a Web service that runs on a Web server. When the report server component is installed, both the Windows service and Web service are installed. You can have one installation of report server on one computer. Report server does not install as multiple instances on one computer.
Report Manager is used to manage report server content and view reports. You can access Report Manager through a virtual directory address on a Web server. If you installed Report Manager locally, you can also use a shortcut on the SQL Server Start menu. To access the shortcut, click Start, point to Programs, point to Microsoft SQL Server, and then point to Report Manager.
Report Server Database
The report server database is a SQL Server database that stores data used by a report server. MSDE and SQL Server Personal Edition cannot host the report server database, though it can be used as a source of data for the reports.
Administrative Tools and Utilities
The following tools and utilities are included with Reporting Services. For more information on the utilities, see Tools and Utilities Reference.
The rsconfig utility is used to modify report server database connection settings after installation is complete. It is also used to set encrypted account information used for unattended report processing. For more information, see rsconfig Utility.
With the rs utility, administrators can process Visual Basic scripts to perform common tasks repeatedly and run duplicate tasks on different computers. For more information, see rs Utility.
With the rskeymgmt utility, you can backup and restore the encryption keys used by the report server. For more information, see rskeymgmt Utility.
The rsactivate utility is used to initialize a report server installation. For more information, see rsactivate Utility.
Authoring Tools: Report Designer
Reporting Services includes a report authoring tool named Report Designer. Report Designer runs within the Visual Studio .NET 2003 environment. You can use Report Designer to create, edit, and preview reports, and then deploy them to a report server.
Documentation and Samples
This feature installs the complete documentation set for Reporting Services, code samples, report samples, and the AdventureWorks2000 database. The documentation is installed to <Reporting Services installation directory>\Help\<language-specific folder>. The code samples are installed to <Reporting Services installation directory>\Samples\Applications, and the database installed to <Reporting Services installation directory>\Samples\Databases. Setup installs the sample database on a local SQL Server instance. If you want to use a remote SQL Server instance, you can run Setup on that computer to install the sample database.
To view Reporting Services Books Online after you complete Setup, click Start, point to Programs or All Programs, point to Microsoft SQL Server, Reporting Services, and then click Reporting Services Books Online - <language>.
To view the samples, click Start, point to Programs or All Programs, point to Microsoft SQL Server, point to Reporting Services, and then click Reporting Services Samples. The default setting is to not install any samples or the database. You must explicitly select these items in the Feature Selection page of the Setup Wizard, or by using the RSSAMPLESFILELOC property in the Setup command prompt.