PRB: Cannot process a cube after you install SQL Server 2000 Analysis Services Service Pack 3 (812601)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services SP3
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.
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 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
| Modification Type: | Major | Last Reviewed: | 8/20/2004 |
|---|
| Keywords: | kbSysAdmin kberrmsg kbprb KB812601 kbAudDeveloper |
|---|
|