PRB: Cannot process a cube after you install SQL Server 2000 Analysis Services Service Pack 3

This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
You may not be able to process a cube after you install Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3), if the Data folder for Analysis Services is located on a different computer than the computer that has Analysis Services installed.

You may receive error messages that are similar to:

Unable to connect to the registry on the server (<computer name>), or you are not a member of the OLAP Administrators group on this server.
-or-

Analysis Server Error: File error [during the Open operation] 'C:\Program Files\Microsoft Analysis Services\Data\FoodMart 2000\Budget'S.mdl Access is denied. ' ; Time:3/18/2003 2:45:58 PM

Analysis Server Error: File error [during the Open operation] 'C:\Program Files\Microsoft Analysis Services\Data\FoodMart 2000\Budget'S.mdl Access is denied. ' ; Time:3/18/2003 2:45:58 PM

Error(-2147221421): Internal error (Server initializing Cube 'Budget' (final)); Time:3/18/2003 2:45:58 PM

Error(-2147221421): Internal error (Unexpected internal error (Cube 'Budget')); Time:3/18/2003 2:45:58 PM
CAUSE
This behavior occurs because the security permissions change on the Data folder when you install Microsoft SQL Server 2000 Analysis Services SP3.
WORKAROUND
To work around this problem, assign the OLAP Administrators group full control of the remote Data folder.
MORE INFORMATION
If you apply SQL Server 2000 Analysis Services Service Pack 3 to an instance of Analysis Services that is running in a clustered environment, you must give the domain-level OLAP Administrators group full control access to the remote Data folder.
REFERENCES
For more information about creating and using the domain-level OLAP Administrators group, see the following article in Microsoft Knowledge Base:
308023 How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
231951 Permissions that you must have to administer an OLAP server
331925 FIX: Pre-Analysis Services Service Pack 3 client cannot administer Analysis Services Service Pack 3
~ processing error OLAP
Properties

Article ID: 812601 - Last Review: 02/27/2014 21:16:29 - Revision: 2.3

  • Microsoft SQL Server 2000 Analysis Services
  • kbnosurvey kbarchive kbsysadmin kberrmsg kbprb KB812601
Feedback