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
What is right outer join in sql server joins?
What are 3 ways to get a count of the number of records in a table?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What is data modification?
What is the purpose of optimization?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is sql server agent and what are the two modes of authentication in sql server?
What xml support does the sql server extend?
When a primary key constraint is included in a table, what other constraints does this imply?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is an index in a database?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
what is sql server? : Sql server database administration
What is the default order of an order by clause?
How do I create an extended event in sql server?