How to setup 2 seperate databases for 2 different customers

[Daniel Liu]

We are deploying the Microsoft EPM Solution to one of our customers in
Siemens, the end users of the system are located at two different
geographical sites and belong to two different R&D teams. However, our
Siemens customer have purchased only one Microsoft Office Project Server 2003
license and we have installed IIS, SQL Server 2000 with SP4, WSS and Project
Server 2003 on one single server, the server is located in cusomer's office.
But for project data management and security reasons, both two end users team
do not want their project data to be viewed by the other team, thus we had
suggested our customer to setup 2 sets of seperate databases(Project server
database and WSS content database) for these two end users team, and allow
them to log on to their unique project server using unique URLs, i.e.
http://tbstd/Projectserver_com for one end user team, and
http://tbstd/Projectserver_scnb for another end user team. Now we are facing
difficulty in realizing this setup configurations, can any expert here offer
your hands to help us?

Many thanks in advance.

 

[Paul Conroy]

In a nut shell and with a few assumptions.

Create a new website for the frontend service and change the port to
something different from the existing listening port, ie 81.

I guess you have a new top level website or sharepoint instance to use.

If the existing PS database is blank take a copy of it and restore it in SQL
with a different name. Create two new SQL accounts Change the
MSProjectServerRole_new db and MSProjectRole_newdb password, add the PS
roles to both accounts.. Remove the existing MSprojectServerRole and
MSProjectRole from the newly restored DB.

If the existing PS database is not blank you can create on manually, then
extend it with some Stored Procs from the installation CD. The installation
manual from the resource kit explains how to do this.

Run the editsite utility and create a new instance. Point the application
to the new PS database and Sharepoint instance.

If you're using OLAP, you will need to create a new cube and assign roles
accordingly.

Users then connect to the new instance through the url
http://server:81/projectserver

 

[FaisalM]

Read this one as well:

http://support.microsoft.com/kb/323021/

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Viren Saini]

Hi daniel,

You might want to visit the site below:
http://blogs.wwwcoder.com/shaunakp/articles/2660.aspx

I had also setup the multiple instances of EPM using this document.

Regards,

Viren Saini

 

[Daniel Liu]

Thanks Viren, but I can not browse your blog page, could you please paste
your solution on this discussion group.

 

[Daniel Liu]

Thanks for yr useful information.

 

[Daniel Liu]

Thank you Paul for your detailed procedures, I will take a try by following
your suggestion.