about creating a database in SSRS installation and configuration process

Question

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.

Answer 1

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.