Select the product you need help with
PRB: Cannot process a cube after you install SQL Server 2000 Analysis Services Service Pack 3Article ID: 812601 - View products that this article applies to. SYMPTOMSYou 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 CAUSEThis behavior occurs because the security permissions change
on the Data folder when you install Microsoft SQL Server 2000 Analysis Services
SP3. WORKAROUNDTo
work around this problem, assign the OLAP Administrators group full control of
the remote Data folder. MORE INFORMATIONIf 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. REFERENCESFor more information about creating and using the
domain-level OLAP Administrators group, see the following article in Microsoft
Knowledge Base:
308023
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/231951/
)
Permissions that you must have to administer an OLAP server
331925
(http://support.microsoft.com/kb/331925/
)
FIX: Pre-Analysis Services Service Pack 3 client cannot administer Analysis Services Service Pack 3
PropertiesArticle ID: 812601 - Last Review: November 21, 2006 - Revision: 2.3
|
Back to the top
