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

Article translations Article translations
Article ID: 812601 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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

Properties

Article ID: 812601 - Last Review: February 27, 2014 - Revision: 2.3
APPLIES TO
  • Microsoft SQL Server 2000 Analysis Services
Keywords: 
kbnosurvey kbarchive kbsysadmin kberrmsg kbprb KB812601

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com