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

This article was previously published under Q293782
This article has been archived. It is offered "as is" and will no longer be updated.
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.
OLAP
Properties

Article ID: 293782 - Last Review: 10/23/2013 17:34:10 - Revision: 1.2

  • Microsoft SQL Server 2000 Analysis Services
  • kbnosurvey kbarchive kbbug kbpending KB293782
Feedback