I'm trying to get Project Server 2007 working with SQL Server 2008 R2 as the backend database. Whenever I try to build the cube, I get this error message:
[4/28/2010 10:33 AM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server [ServerName]. Error: Your permissions on the server computer do not allow you to administer this Analysis server.
I followed the directions outlined in this link: http://technet.microsoft.com/en-us/library/dd285466.aspx
Can someone please help me troubleshoot? Thanks!!