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

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.

date: Tue, 23 Oct 2007 07:50:01 -0700   author:   JackQCY

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

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


"JackQCY"  wrote in message 
news:2885910E-4BC7-44DA-A67B-8965A6967C6C@microsoft.com...
>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.
>
>

date: Tue, 23 Oct 2007 16:16:31 +0100   author:   Mike Glen glenATmvps.org

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

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.


"JackQCY"  wrote in message 
news:2885910E-4BC7-44DA-A67B-8965A6967C6C@microsoft.com...
>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.
>
>

date: Wed, 24 Oct 2007 14:29:28 +1000   author:   Daniel Beale