Project 2007 Cube Building Service

[DigitalPhreak]

I have installed and Im using PS2007. One of my associates wants to use the data analysis feature. However, I cannot get the server to build a cube. I followed all of the instructions found here-->

http://technet2.microsoft.com/Offic...57d2-4120-81f3-6ff04e6b3f721033.mspx?mfr=true

I keep getting an error that says the server could not connect to the analysis server when I attempt to build the cube.

PS2007 and SQL2005 are on the same server.

This is the error I get. Please point me in the right direction if you can. I really dont even know where to begin as I am a complete newb when it comes to SQL.

The errors returned from the queue are as follows:
Error ID: 17003
Error ID: 26000

Detailed error below - send it to the administrator for more detailed troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure" uid="5abc4d31-2f11-406a-9a93-acb0c5150859" QueueMessageBody="Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=galileo ASDBName=tombaprojects ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=05/17/2007 09:42:44 ToDate=05/17/2007 09:42:44 HighPriority=True" Error="Analysis Services session failed with the following error: Failed to connect to the Analysis Services server galileo. Error: A connection cannot be made. Ensure that the server is running." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed" uid="4f24a213-646d-4e11-a04a-2a61ef27fca6" JobUID="2f41350e-0cd7-4b95-bbae-035d2fbe1c15" ComputerName="GALILEO" GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

 

[PDQBach]

You _might_ find that this has something to do with an SSPAdmin account not being in the OLAPAdmin group (or one of the other Admin groups).

But don't quote me ... I'm a Project guy, not a PrjServer guy.

 

[DigitalPhreak]

Pardon me, but I dont know what SSPAdmin is. As I have read around it has something obviously to do with project. However, I cannot find this particular user on my project server. Was it supposed to be a default creation?

 

[PDQBach]

Admin account for the Shared Services Provider. And you have now *totally* exhausted all my knowledge about PrjServer <grin>.

 

[DigitalPhreak]

Thanks for your replies but I have seen nothing of the sort as of yet... Can anyone else help a little more in depth.