PS 2003/SQL Server 2005 - OLAP cube issues

[Char]

Hi - I'm having trouble creating an OLAP cube in a PS 2003/SQL Server 2005
environment. Can someone please provide me with information on whether the
OLAP cube is supported in this environment. Some threads from a few months
ago said that SQL Server 2005 does not work with PS 2003. Is this still the
case?? If not what is the possible workaround? Is there a hotfix that I need
to apply?
Any help would be appreciated!
Thanks

 

[Marc Schoeni]

Hi,

It is possible to run the Project Server 2003 database on SQL Server 2005,
you will need to switch to SQL 2000 compatibility mode for the specific
database.

For the issue you're having with the OLAP cube refer to the following KB
article: http://support.microsoft.com/kb/921116/en-us

Let us know if this helps.

Marc S.
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com