Sql server > SSRS >> Business Intelligence Views : 5076
Rate This Article :

Reporting Services Components

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:

  • Databases
  • 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:

service_architecture-1.png

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.

About Author
Kirthikaa A S
Total Posts 5
-
Comment this article
Name*
Email Address* (Will not be shown on this website.)
Comments*
Enter Image Text*
   
View All Comments
Comments not posted yet!! Please post your comments on this article.
  Privacy   Terms Of Use   Advertise With Us   Contact Us
© 2016 Developerin.Net. All rights reserved.
Trademarks and Article Images mentioned in this site may belongs to Microsoft and other respective trademark owners.
Articles, Tutorials and all other content offered here is for educational purpose only and its author copyrights.