Cube Processing Issue

[peter feakins]

We're trying to build a cube through Proeject Server 2007. We are geting the
following error: Your permissions on the server computer do not allow you
to administer this Analysis server.

I've followed the following article in setting up permissions. We used SQL
Server 2005 as the reposiotry so we followed that option.

http://technet.microsoft.com/en-us/library/cc197552.aspx

I stopped and restarted the analysis services after giving the SSP account
server admin rights in AS. The DSO connection strings are configured to use
windows authentication and the SSP has the permissions in SQL Server as
indicated by the article.

I've used profiler to trace both AS and SQL Server during a build and did
not see any errors or failed logins. Any recommended next steps?

thanks

 

[Rudolf]

Hi Peter,

try filemon to trace what's happening and look for a access denied
entry.

Regards,
Rudolf