FIX: No error occurs when you open OLAP Manager if user account is not a member of the OLAP Admin or local Admin group

This article was previously published under Q255087
This article has been archived. It is offered "as is" and will no longer be updated.
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.
w2000, w2k, win2000, win2k, mmc

Article ID: 255087 - Last Review: 02/28/2014 00:31:15 - Revision: 4.3

Microsoft SQL Server OLAP Services

  • kbnosurvey kbarchive kbbug kbfix KB255087