I have a deployment with SqlServer 2000 and Analysis Services. Both are
running on the same physical box. I have a web application that is
accessing the cube via OLEDB calls. After some time, the OLEDB calls start
to return with an OleDbException with the message "Access denied to the cube
XXX". The permissions are still set (verified with the Analysis Manager).
I've tried removing and re-adding the permissions with no luck. The only
solution that has worked consistently is to re-process the cube. As soon as
the re-process has completed, the cube can be accessed again.

I've search MSDN and this news group with no luck. Does anyone have any
clues why this might be happening and what I can do to prevent it?

Thanks,
Phil

Phil,

You get the error:

Microsoft OLE DB Provider for Analysis Services
(0x80004005)
Access denied to the cube <cube>.
when attempting to access a cube that has been processed
but not yet had roles applied; or, you are accessing a
cube with a user that does not have proper permissions.

Also please see that you connect to your SQL Server
database using SQL Server authentication and not Windows
Authentication.

Hope this helps.
Geeta