all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

Install RS for multiple websites on single computer


Install RS for multiple websites on single computer Dilip Kumar
10/31/2005 6:38:09 PM
sql server reporting services: My understanding is that RS installs ONLY on the default website. I'm hosting
four websites on a single IIS computer. I want to use Reporting Services
separately on each of the websites. That is, each will have its own database
and its own set of reports. Is this possible? How?

Thanks.
RE: Install RS for multiple websites on single computer Mahesh Gaware
11/1/2005 10:51:05 AM
Dilip,
I am not sure if you can host multiple instances of RS on single server,
but I have achieved the same requirement by creating a separate directory for
each application. Each corresponding application can have separate directory
with its Reports and required Dataset.

Hope this helps.

Mahesh

[quoted text, click to view]
RE: Install RS for multiple websites on single computer Dilip Kumar
11/1/2005 11:10:02 AM
Thanks for your reply, Mahesh.

I want to keep all the domains separate. I want to access each set of
reports as follows:

http://www.companyA.com/Reports
http://www.companyB.com/Reports
http://www.companyC.com/Reports
http://www.companyD.com/Reports

Dilip

[quoted text, click to view]
RE: Install RS for multiple websites on single computer Mahesh Gaware
11/1/2005 11:26:14 AM
hi Dilip,
hmm.. I am sorry, I have no idea about how this can be acheived using
single IIS server for single RS instance.

Thanks,
Mahesh

[quoted text, click to view]
Re: Install RS for multiple websites on single computer Peter Nolan
11/2/2005 8:51:21 AM
Hi Dilip,
I have been thinking about how to do this as I have been thinking of
doing the same....though I am coming to the conclusion it is probably
best to have one server per customer.....

However, my thoughts on the subject were as follows...

1. Set up links or domains for each customer.
2. repoint the domains into a single dot net nuke portal (I am
considerign using dot net nuke www.dotnetnuke.com) as the 'BI portal'
for clients.....probably a release 2.0 thing for me now.
3. User signs in or can now use integrated security for DNN but if you
have multiple companies on one server you are probably going to host
the server outside their security domains so you need a way to securely
log them into DNN.
4. Present reports inside the DNN environment which will allow you to
have the users looking at the one IIS server and one database without
each customer knowing about the other......you control where the users
point to for each report or directory so you can just set up different
directories for different customers.

5. You could even set graphics etc from the userid or portal you were
looking at so the clients saw different formats etc inside their BI
portal...

Having played with all this...I thought it was easier just to get the
clients to pay for one machine each...

Peter
AddThis Social Bookmark Button