Why cant I use ENTERPRISE options for Project Server?

[Timothy Cocaro]

Hello all,

I have successfully installed MS PROJECT SERVER 2003 on SBS 2003 PREMIUM
EDITION running SQL SERVER 2000.

I have done so by following http://www.sbslinks.com/pdf/ProjectServer.pdf
and without installing ANALYSIS SERVICES... BUT

In this help guide it says "SQL for SBS does not support these enterprise
features"... why not???? is it because this guide did not install ANALYSIS
SERVICES or is it because I need SQL Enterprise Ed? I would like to be able
to use the enterprise edition if possible but dont want to start guessing
why this help guide which everyone seems to refer to says that it cannot be
done.

Any help would be appreciated.

Thanks in advance,
Timothy Cocaro

 

[Gary L. Chefetz [MVP]]

Timothy:

You don't need SQL enterprise. Can you quote the passage at least by page
number?

 

[IISJUNKIE]

Alot of NON supported deployment of Project Server is because the "all - in -
one" setup is just not possible. Some features of SBS include a default
sharepoint site, a HTTP RDP functionality that can allow you to remote
desktop into SBS via a web page, and SQL Server also uses web components to
provide different displays of properties like metadata settings or whatever,
not to mention SBS has a built in EXCHANGE mail server with WEB access
features as well.. So let me put it this way:
If SBS by Default uses the same COM+/ DLL's / Default web Application Pools
in IIS, then what will ProjectServer Use when it creates it's 4 App_Pools
that "it needs to run"??? That's why it's failing. If you want to leverage
SQL, Project Server & SBS - ALL ON ONE SERVER then do this:
uninstall everything on SBS except IIS -
Install Microsoft Virtual Server 2005 only - this will use the default IIS
functionality
Create 2 Virtual servers on the same box one for SQL2000 and one for
MSPS2k3. That way you have all your eggs in one basket and are able to make
the whole thing work without applications fighting over the same
Process/Service/CPUID/COM+ & DLL that make each product work fine when
installed individually on separate servers.

Hope this Helps,

Good Luck