MS SQL Reporting Services Interview Question:

What is the architecture of MS SQL Reporting service?

Submitted by: Administrator

Reporting Services runs as a middle-tier server, as part of your 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.
Submitted by: Administrator