BUG: Can Only Administer Analysis Server if User is a Member of Administrators Group (293782)


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q293782
BUG #: 12010 (plato7.x)

SYMPTOMS

You may see error messages when you attempt to administer Analysis Services with a user who belongs to the OLAP Administrators group, but does not belong to the Administrators group. After you add the user to the Administrators group, the errors do not occur.

CAUSE

The OLAP Administrators group does not have full control of the repository file, Msmdrep.mdb. So, when an object is changed or added, Analysis Services attempts to write or modify the repository file and fails because of the lack of security rights. Having the user in the Administrators group provides the user sufficient rights to modify the repository.

WORKAROUND

To work around the issue either:
  • Migrate the repository to Microsoft SQL Server where file security is not a problem.

    -or-

  • Manually change the directory and file security to give the OLAP Administrators full control of the Msmdrep.mdb and Msmdrep.ldb files. These files are located in the Bin folder of Analysis Services.

STATUS

Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000 Analysis Services version 8.0.
Modification Type:MinorLast Reviewed:4/24/2003
Keywords:kbBug kbpending KB293782 kbAudDeveloper
©2002 Microsoft Corporation. All rights reserved.