Re: Approach for hosting multiple business units on the same server

From: Nico Oosthuysen (johndoe_at_doe.com)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 14:45:57 +0200

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? 

--
Nico Oosthuysen
Fulcrum Business Solutions
www.fulcrumgroup.co.za
"Abhijeet" <going4matrix@yahoo.co.in> wrote in message
news:73d733b4.0402100953.5d90e1cd@posting.google.com...
> 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.

Relevant Pages

  • Re: Issue with Migrating OLAP Cube
    ... > uat server, but the underlying SQL database differs. ... > I tried your #2 using my AS dbname1 on my dev machine. ... I copy those same cubes from ...
    (microsoft.public.sqlserver.olap)
  • Re: DISCOVER_XML_METADATA
    ... expansion of ASSL XML returned by the server. ... You could do ExpandObject for the server in step 1. ... you could request ExpandObject for that database -- this is step ... all cubes and nothing else. ...
    (microsoft.public.sqlserver.olap)
  • Re: Issue with Migrating OLAP Cube
    ... I tried your scenario and it works fine. ... uat server, but the underlying SQL database differs. ... I copy those same cubes from ...
    (microsoft.public.sqlserver.olap)
  • Re: Approach for hosting multiple business units on the same server
    ... > 2.0) while the second box hosts SQL Server database. ... > I created sites for each business unit using the SiteEdit utility ( ... > each business unit with have an OLAP database where they can create ...
    (microsoft.public.project.pro_and_server)
  • Approach for hosting multiple business units on the same server
    ... We are implementing Project Server 2003 and Sharepoint services 2.0 ... I created project server database for each business unit using ... I created sites for each business unit using the SiteEdit utility ( ...
    (microsoft.public.project.pro_and_server)
Loading