October 8, 2018 at 10:18 pm
Hi,
When I open SSMS and expand databases I see "report server" and it has some tables such as "data set"s and "data source" etc
What is the use of report server ?
What is the use of data sets and data source tables?
If it is used for reporting then how the SSDT( reports) and report server are linked?
Can report server and reporting data be on different server?
What is the use of "report Server TempDB"?
Sorry if I asked any dumb questions but I am trying to learn.
Thanks,
SQL server learner.
October 9, 2018 at 7:31 am
sizal0234 - Monday, October 8, 2018 10:18 PMHi,When I open SSMS and expand databases I see "report server" and it has some tables such as "data set"s and "data source" etc
What is the use of report server ?
What is the use of data sets and data source tables?
If it is used for reporting then how the SSDT( reports) and report server are linked?
Can report server and reporting data be on different server?
What is the use of "report Server TempDB"?Sorry if I asked any dumb questions but I am trying to learn.
Thanks,
SQL server learner.
The ReportServer and ReportServerTempDB databases are used by reporting services. They have the meta data used by reports in Reporting Services. It's not the same as the data displayed on reports in Reporting Services - the data can be from many different data sources. The explanation and use of the databases is documented:
Report Server Database
Sue
October 9, 2018 at 7:44 am
This also may be a good place to start:
http://www.sqlservercentral.com/stairway/72382/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply