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

SYMPTOMS

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.

CAUSE

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.

STATUS

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 information about how to download and install the latest SQL Server OLAP Services Service Pack, see the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=f62f45e9-24ed-4fa6-bd74-8a26606f96d8&DisplayLang=en

For more information, contact your primary support provider.

MORE INFORMATION

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.