Reporting Services Components - Databases
By: Ray Barley
Reporting Services creates and uses two SQL Server 2008 databases named ReportServer and ReportServerTempDB by default. The ReportServer database has tables to store reports, data sources, snapshots, subscriptions, etc. It is the repository for the reporting application data. The ReportServerTempDB database is used for temporary storage needs, as the default name suggests. When you allow the SQL Server 2008 installer to configure Reporting Services, these two databases are created automatically for you. If you want to create them manually, then you need to use the Reporting Services Configuration Manager. In this tutorial we assume that the SQL Server installer is used to configure Reporting Services.