I'm brand new to SSRS and just installed RS2000. I have seen numerous posts/articles about how to set up RS2000 on the non-default website, but haven't been able to figure out if you can install it on multiple websites on the same server.
Here's my situation: we have multiple clients who run our software on the same server. Each client has their own db and their own website in IIS. I'd like to provide each client with access to reports through their own website that report on their own database. Is this possible at all? From what I'm finding, I don't think it is (it seems SSRS can only be installed on one site), but figured I would ask to determine whether I should explore the use of SSRS any further. If it isn't possible in RS2000, is it possible in RS2005?
I also have two other questions that I would need to figure out an answer to if it is possible to run RS2000 on multiple websites. First, is there a way to customize the look and feel of the reports? In other words, is there a way to add a header/leftnav/footer? It seems that I could use a frameset to load my header, footer, and leftnav, and then just point my main frame to the /reports/ or /reporserver virtual dirs. Is there a better way than that?
Secondly, is there a way to turn off access to most of the admin features available through the /reports/ directory. For example, we wouldn't want our clients to have access to "New Data Source", "Site Settings", etc. We'd just want them to access the reports we generate. It seems we could point them to the /reportserver/ directory and just put some custom pages in there to point at the reports (I just get a directory listing by default). Is there another way to do this?
Thanks,
Dave
This helps:
http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/default.aspx
No comments:
Post a Comment