Architecture of SQL Server Reporting Services

Explain the architecture of reporting services.

- Reporting Services runs as a middle-tier server as part of the existing server architecture.

- SQL Server 2000 should be installed for the database server, and Internet Information Services 6.0 as a Web server.

- The report server engine takes in report definitions, locates the corresponding data, and produces the reports.

- Interaction with the engine can be done through the Web-based Report Manager, which also lets you manage refresh schedules and notifications.

- End users view the report in a Web browser, and can export it to PDF, XML, or Excel.
SQL Server Reporting Services lifecycle
SQL Server Reporting Services lifecycle - The phases of the Reporting Life Cycle involve:..
Ways to tune SQL Server Reporting Services
Ways to tune SQL Server Reporting Services - Following are a few ways you can tune up Reporting Services:....
How to schedule SSAS Database backup
How to schedule SSAS Database backup - SSAS database backups can be taken using SQL Server Management Studio (SSMS)....
Post your comment