Microsoft KB Archive/255087

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

Article ID: 255087

Article Last Modified on 7/31/2006

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q255087



BUG #: 4524 (Plato7x)



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.

Additional query words: w2000, w2k, win2000, win2k, mmc

Keywords: kbbug kbfix KB255087

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.