Stand-alone install of Project Server 2007 with SQL Server 2005 St

[JackQCY]

I recently did a stand-alone install of MS Project Server 2007 and SQL Server
2005 Express was installed as part of the process. Things worked fine until I
realized that I needed the analysis services component of SQL Server to do
more advanced reporting (creation of OLAP cubes). Therefore, I upgraded from
SQL Server Express to SQL Server 2005 Standard Edition. However, I'm unable
to create OLAP cubes because of a failed connection to analysis services and
I really want to do a clean re-install. My question is, if I were to
uninstall both SQL Server and Project Server, re-install SQL Server 2005
Standard Edition, and then do a stand-alone reinstall of Project Server 2007,
would MS Project Server 2007 use the instance of SQL Server 2005 standard
edition already installed or would it still go through the process of
installing SQL Server Express? If a stand-alone install always installs
express, I suppose I would have to choose the option to do a server farm
implementation even though I'd be installing everything on the same server
(DB, application, front end, etc.)?



My intent is to do the most simple installation I can and getting analysis
services to work.



Thanks for your help.

 

[Mike Glen]

Hi Jack,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

 

[Daniel Beale]

yep, "I suppose I would have to choose the option to do a server farm
implementation even though I'd be installing everything on the same server "
is correct, And this is not an exercise to be taken lightly! I have just
been through setting up MOSS and PS on a single development server. In the
end there is no shortcut, the knowledge required is the same as setting up
on multiple servers. You have to configure many ad accounts, and many
services in the correct order and understand the different bits of
sharepoint. You should probably also consider installing MOSS, as this
allows addressing much more of the big 'project management' picture.

regards
Daniel.