Microsoft KB Archive/293782

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

Article ID: 293782

Article Last Modified on 11/21/2006

-

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.

Additional query words: OLAP

Keywords: kbbug kbpending KB293782

-

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

© Microsoft Corporation. All rights reserved.