PS 2003 and SQL Server 2005 SP2 - OLAP issues

[Char]

Hello -

Does PS 2003 SP2a work with SQL Server 2005 SP2. I'm having OLAP cube build
issues that I did not get when I was running SQL Server 2005 SP1.

I get this error when I try to build to cube: (I did the recommended steps
on how to build a cube with PS 2003 and SQL server 2005 SP1). This looks like
an issue with SQL Server SP 2 but I just want to make sure from someone who
has more knowledge.

The cube scheduled to be built on 4/25/2007 at 10:54 AM failed.
(-2146232832) My OLAP Server;cube1;MSP_ASSN_FACT: Cannot parse the JoinClauseâ€

Any help would be appreciated.

Thanks,
Char

 

[NZ Projects]

(re)-apply Project Server 2a to all server/db components.

 

[Char]

How do I re-apply SP2a. When I try to do so it says that the service pack has
already been applied. I can't remove the service pack from the Add/Remove
Programs either. Have you dealt with this in the past? Please help. Thanks!