Error when trying to build OLAP Cube

[irish_archer68]

Hello everyone,

I am running a 'normal' build of MS Project Server 2007 with SQL 2005
and SRS 2005.

I believe it is a 3 server configuration. I also believe Analysis
services has been properly configured.

I am getting the following error when trying to build an OLAP cube
from Project server:

===== Building database and cubes =====
[9/12/2008 9:59 AM] Cube build session started
[9/12/2008 9:59 AM] Analysis Services session started
[9/12/2008 9:59 AM] Analysis Services session failed with the
following
error: Failed to create the Olap database: ProjectServer_OLAP. Error:
Invalid procedure call or argument
===== Process Completed =====
[9/12/2008 9:59 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Failed to create the
Olap database: ProjectServer_OLAP. Error: Invalid procedure call or
argument

Has anyone seen this before or have any thoughts on a trouble shooting
process to resolve?

Thank you in advance for your assistance.

 

[Paul Conroy]

Has this ever worked ? If so, what's changed?

If not, then you missed a step in the configuration/settings. Go through
the instructions detailed in the following article. Don't assume that
everything is configured correctly.

http://technet.microsoft.com/en-nz/library/cc303402(en-us).aspx