question

ArunRaaman-6281 avatar image
0 Votes"
ArunRaaman-6281 asked Joyzhao-MSFT commented

about creating a database in SSRS installation and configuration process

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @ArunRaaman-6281 ,
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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello Joyzhao,

Thank for giving your valuable; the explanation you gave is really satisfying. However, I am curious to know the source of information from which you drew the summary of your understanding, this is because I wanted to understand the related information.

Thank you again!

0 Votes 0 ·

Hi @ArunRaaman-6281 ,
After you have used SSRS many times,, you will also have a deeper understanding of SSRS. Of course, official documents and official forums are also a place to improve knowledge reserves.
If you have any questions about SSRS on Q&A, you could always feel free to let me know.
Best Regards,
Joy

0 Votes 0 ·