Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-10-25 : 16:37:10
|
| Hi,We have reporting services installed on computer A. Reporting services databases reportservice and reportservicetemp db created on another database server.Right now there is request to add reporting services database for one application. Can I just add reporting services databases to existing reporting server A or I have to install new reporting services instance.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 16:42:30
|
| reporting services dbs are created separately for each instance of reporting services so I think you need to install new one. i didnt understand why you need report services db for another application though. These are actually internal dbs maintained by report services instance so I cant think of reason why you want another application to access them unless you want to do something with report server metadata------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-10-25 : 17:28:16
|
| Thanks for reply.Where reports are stored? Say Application 1 have to access some reports. Application 2 have to access some other reports. So what you think, these reports are not stored in reportserver database or they stored somewhere else. In our environment we have reporting services installed on reporting services application services and reports are stored in databases they are on database server. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 17:32:21
|
quote:
Originally posted by Peter99
Thanks for reply.Where reports are stored? Say Application 1 have to access some reports. Application 2 have to access some other reports. So what you think, these reports are not stored in reportserver database or they stored somewhere else. In our environment we have reporting services installed on reporting services application services and reports are stored in databases they are on database server.
why does application have to access them from database?whats this application? if its .net you've report viewer control which you can include in application and call report through it. Another way is to access rdl (report file) using webservices. Its just a matter of configuring correct report server for application to fetch reports from them------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Reporting Services