MS SQL Reporting Services Question:

Download Job Interview Questions and Answers PDF

What is the architecture of MS SQL Reporting service?

SQL Reporting Services Interview Question
SQL Reporting Services Interview Question

Answer:

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.

Download SQL Reporting Services Interview Questions And Answers PDF

Previous QuestionNext Question
Explain How does the report manager work in SSRS?What is MS SQL Server Reporting Services?