Standalone Install of PS 2007 with SQL Server Std. Edition install

[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 the install of 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 get analysis
services to work.

Thanks for your help.

 

[Brian Smith \(MSFT\)]

Hi Jack - you will need to do a farm install if you want to choose your db
instance, but you can still end up with everything on the same server. For
the OLAP setup
http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx
will tell you all you need to know.

Brian.