about creating a database in SSRS installation and configuration process

ArunRaaman 991 Reputation points
2021-07-30T15:07:09.317+00:00

hello there,

I recently configured SSRS following some online documentation. In the process of configuration, I remember I created report database in database engine.

my concern is, whether what I did is correct or not? what is the purpose of report server that is accessible in SSMS?

Would anyone please help me understand?

Thank you for giving your valuable time.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,827 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-08-02T02:35:06.743+00:00

    Hi @ArunRaaman ,
    In short, ReportServer Database and ReportServerTempDB Database are used as permanent data storage and temporary storage, respectively. The database is simply used to store all information, such as report definitions, subscription information, and so on.

    A report server is a stateless server that uses the SQL Server Database Engine to store metadata and object definitions. Report Server will use the data in the database for transaction processing, such as forming reports, mounting websites, and processing data.

    More information about ReprtServer Database: Report Server database.
    More information about ReprtServerTempDB Database: Report Server temporary database.
    Hope this helps.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful