Approach for hosting multiple business units on the same server

A

Abhijeet

We are implementing Project Server 2003 and Sharepoint services 2.0
for various business units on same servers. The business units are
small so we have create an environment with two boxes. The first box
hosts Application server (Project Server 2003, IIS 6 and Sharepoint
2.0) while the second box hosts SQL Server database.

Here is what I did…..
I created project server database for each business unit using
SETUPDB.CBD utility and following the instructions in Installation
Guide ( pg 63)

I created sites for each business unit using the SiteEdit utility (
Downloaded from Microsoft site)

Now from here I am confused….
Should I create a separate Sharepoint Configuration database for each
business unit? As far as possible we want to keep everything separate
for each business for two reasons.
1. Localize any kind of problem.
2. Ability to move one business unit from one server to another if we
each business decide to get their own server and not host in common
environment.

I believe I will have to create separate content database for each
business unit assuming if we decide to use one Configuration database.
Correct me if I am wrong.

How do I make sure each business creates OLAP cubes in their own OLAP
database I want to create seperate OLAP database for each business
unit and attach them to respective Project Server database. This way
each business unit with have an OLAP database where they can create
their cubes. I have realized that there is no way for attaching
Analyzer services with multiple databases. All the cubes created in
multiple sites end up in one database.

Thanks for taking time to read this post. Any pointers are
appreciated.
 
N

Nico Oosthuysen

Hi Abhijeet,

If you are trying to keep everything seperate as far as possible, then yes,
the best way would be to use seperate db's for each of the WSS instances.
The easiest way to do this, is to create another Virtual Server in IIS
(pointing to another port, such as 8080 instead of the standard 80). You
can then extend this virtual server in WSS, and apply the Project Server
templates to it as well. Then when you add the information in into Project
Server, you still use the same Sharepoint Administratoin URL, however you
would use the URL of the second virtual server that you created for the
project workspaces.

For example, if your default project server URL is
http://servername/projectserver, you would then create a second Virtual
Server in IIS that points to, say Port 8080. The URL that you would then
add into the WSS Server page in PWA, would then be
http://servername:8000/sites.

With regards to the OLAP cubes - i am not sure how you can limit them to use
only their specific OLAP cube. Maybe you could build the cube the first
time, and set your permissions in such a way that the users cannot change
the cube name later on?

Please let me know if my answer made any sense?
 
N

Nico Oosthuysen

Hi Abhijeet,

I forgot to add - please post your questions in the new newsgroup as this
one is closing down! The new group is microsoft.public.project.server
 
Top