[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 946
  • Last Modified:

reportserver and reportservertempdb use with reporting services

I just installing reporting services for sql2005,now I can see a db call reportserver and reportservertempdb, but not so sure how this both db can be use to integrate with my new reporting, if I use a normal db what will be a difference between using these db?
1 Solution
ReportServer and ReportServerTempdb are two databases used by Reporting Services to store the reports, their settings and some temporary data (like report snapshots if use them). AFAIR you can configure Reporting Services to use your own databases. Reporting Services will create its structures in those databases. But I suggest to use dedicated databases for Reporting Services (and I think leaving the default names can help anyone who will work with your server).
motioneyeAuthor Commented:
if I have a db called northwind, how this db being related with above db use for reporting?

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now