Article ID: 255087 - View products that this article applies to.
This article was previously published under Q255087
BUG #: 4524 (Plato7x)
If you log on to Windows 2000 with a user account that is not a member of the local OLAP Administrators or Administrators group of the server computer, and you try to open the OLAP Manager from there, you should get an error. However, no error occurs. If you look at the Task Manager, you see that the Mmc.exe file has a high value in CPU utilization but you will find no OLAP Manager displays on your screen and you do not receive any error message.
OLAP Manager creates a temporary folder under the folder \Program Files\OLAP Services\Help\Metadata\Metadataxxx. If the user log on does not have access to create this folder, OLAP infinitely tries to open rather than exit after a few retries.
Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0. This problem is first corrected in U.S. Service Pack 2 for Microsoft SQL Server OLAP Services version 7.0. For more information, contact your primary support provider.
After you apply the latest service pack for SQL Server OLAP Services, you will see this error message instead of being caught in a continuous loop:
Could not start the OLAP Manager. Make sure you have administrator permissions.