What is Report Server,Report Manager and Report Builder in
SSRS 2005?

Answer Posted / bruhaspathy medishetty

Report Server is not a tool when you compare it with Report
Manager or Report Builder.

Report Server can be defined as the Server which has SQL
Server Reporting Services Installed. All the reports are
generated and processed before rendering on this Server.

Report Manager is the one tool which is used by SSRS
Admin/Developer to manage the reports, Data Sources, Roles
and Schedules etc. There is a Browser based Report Manager
apart from the one available from the Management Studio.

Report Builder is again a browser based tool that enables
in creation of adhoc reports by end users without really
knowing much about the underlying Database Details.

See SQL Server Books Online for more.

Thanks,
Bruhaspathy
www.learnsqlwithbru.com

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a natural primary key?

530


How many databases instances are there in sql server 2000?

591


how to invoke a trigger on demand? : Sql server database administration

573


What is the difference between osql and query analyzer?

558


Explain filtered indexes benefits?

610






How many replicas are maintained for each SQL Azure database?

128


on line cluster can we make if yes tell me the procedure

1521


How to turn off warning messages during php execution?

539


What is sql collation?

661


What are the different types of normalization?

635


When a primary key constraint is included in a table, what other constraints does this imply?

609


What do we need queues in sql service broker?

528


application server is slow what may be the problem

1794


What does it mean to normalize a database and why would you do it?

542


How do I find the size of a sql server database?

503