What is SSRS - SQL Server Reporting Services(SSRS) Interview Questions and Answers

SSRS stands for SQL Server Reporting Services which is server-based report generation software from Microsoft. To work with SSRS , there are different tools(components) provided so we can develop report, deploy reports,manage permissions and view reports.

SQL Sever Data Tools ( SSDT)

Business Intelligence Development Studio (BIDS) is old IDE which we were using to develop SSIS Packages,SSRS Reports or create SSAS cubes. Now we are using SQL Server Data Tools(SSDT) to perform the same tasks. By using SSDT you can create Data Source, Shared Datasets and reports. You can also deploy your reports to report server by using SSDT.

Report Builder:

Report Builder is tool which is mostly used by the business users to create their own reports. By using the report builder they can use Data Sources from Report Server, Create the Report and Publish to Report Server if they have permission. The latest version available for Report Builder is 3.0.

Report Server: 

As per Microsoft : https://msdn.microsoft.com/en-us/library/ms157231.aspx

A single report server instance is defined by the complete collection of processors and extensions that provide end-to-end processing, from the handling of the initial request to the presentation of a finished report. Through its subcomponents, the report server processes report requests and makes reports available for on-demand access or scheduled distribution.

Functionally, a report server enables report authoring experiences, report rendering, and report delivery experiences for a variety of data sources as well as extensible authentication and authorization schemes.

Report Database:  

As per Microsoft website: https://msdn.microsoft.com/en-us/library/ms157231.aspx
A report server contains report server databases that store published reports, shared data sources, shared datasets, report parts, shared schedules and subscriptions, report definition source files, model definitions, compiled reports, snapshots, parameters, and other resources. A report server also enables administration experiences for configuring the report server to process report requests, maintain snapshot histories, and manage permissions for reports, data sources, datasets, and subscriptions.

Report Manager:

Report Manager is Web based interface that can be used to perform different tasks such as
Administer the Report Server,View the Reports and Manager the Reports etc.

Reporting Services Configuration Manager:

Reporting Services Configuration Manager can be use to define or modify settings for Report Server and Report Manager.


  1. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.ifrs 16 leases in abu dhabi

  2. It would seem that law firms would have no problem hiring the best court reporters. But that's often not the case, especially for smaller law firms that don't have a human resources department. Twitter

  3. I feel this is among the such a lot vital info for meCashflowbest

  4. to thank you again concerning the respectable suggestions you've contributed. top audit firms dubai

  5. Enjoyed reading your blog. Please check my latest post on the chartered accountant in Dubai  and let me know what you think.

  6. I am so gleeful when i found your weblog while I was researching on Bing for something else,but believe me the way you interact is literally awesome I do respect that so much. I will instantly get your rss and stay informed of any updates you make and as well take the advantage to share some vital information regarding. how to legally live in cyprus I will also take the advantage to ask for your permission to join our TELEGRAM GROUP

  7. Do you want golden visa uae? You can connect with Spiderbc. We will answer all your issues related to Dubai visas assist you throughout the whole process, and help you acquire it at a low cost.

  8. If you're planning a replacement business setup in Dubai and wondering where to line up a business in Dubai? Then you want to know that Dubai has made the foremost of its demographical structuring to become a number one center for dynamic business activities.

  9. Its really appealing and approaching content for reading and implementation purpose.
    accounting software uae

  10. great and approaching content for blogging purpose.
    ERP Software Dubai

  11. Great blog on SSRS (SQL Server Reporting Services).I ready your blog I just figure out that you are not using any email marketing services. I have a website that providing dedicated smtp server for bulk mailing for email marketing.

  12. This comment has been removed by the author.