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)
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:
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
Contact us for more help