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

Article translations Article translations
Article ID: 293782 - View products that this article applies to.
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)
Expand all | Collapse all


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.


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.


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


  • 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.


Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000 Analysis Services version 8.0.


Article ID: 293782 - Last Review: October 23, 2013 - Revision: 1.2
  • Microsoft SQL Server 2000 Analysis Services
kbnosurvey kbarchive kbbug kbpending KB293782

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com