Reporting Services Components:
SQL Server Reporting Services 2008 (SSRS) is a full-featured application that provides report design, development, testing, and deployment. Main components of the product:
- Windows Service
- Report Designer
Reporting Services Components – Databases:
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. It is the repository for the reporting application data.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.
Reporting Services Components - Windows Service:
The Reporting Services Windows service provides the following functionality:
About Windows service:
- The HTTP listener is a new feature, prior versions of Reporting Services required Internet Information Server (IIS). With Reporting Services 2008 IIS is no longer required.
- Report Manager is an ASP.NET application that provides a browser-based interface for managing Reporting Services. We will cover the Report Manager in a later section.
- The Web Service is also implemented as an ASP.NET application. It provides a programmatic interface to Reporting Services. The Report Manager uses the web service. You can use the web service to create your own custom implementation of any feature provided by the Report Manager.
- Background Processing provides the core services for Reporting Services.
- The Report Manager, Web Service, and Background Processing are each implemented as separate application domains.
Reporting Services Components - Report Designer :
The Report Designer provides the capability to design, develop, test and deploy reports. It is a developer-centric tool called Business Intelligence Development Studio (BIDS) that comes with SQL Server 2008. The 2008 version of BIDS has an updated user interface, and many new charts and graphs for enhanced visualizations.