Article ID: 319634
Article Last Modified on 11/21/2006
APPLIES TO
- Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q319634
BUG #: 12647 (plato7x)
SYMPTOMS
You cannot create or process a Microsoft SQL Server Analysis Services OLAP database for a user who belongs to the OLAP Administrators group but does not belong to the Administrators group.
CAUSE
The OLAP Administrators group does not have full control of the repository file Microsoft Analysis Services\Bin\Msmdrep.mdb. So, when a user who belongs to the OLAP Administrator group creates or processes an OLAP database, Analysis Services tries to write or modify the repository file. The process fails because the user account does not have suffcient privileges to write or modify the repository file.
WORKAROUND
To work around the problem, change the folder and file security manually 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 Analysis Services\Bin).
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
If the Analysis Server repository is migrated to SQL Server 2000, and SQL Server 2000 is set to use Windows Authentication, the workaround for this problem is to grant DB_OWNER permissions to the OLAP Administrators group on the repository database.
REFERENCES
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
231951 : Permissions That You Must Have to Administer an OLAP Server
293782 BUG: Can Only Administer Analysis Server if User is a Member of Administrators
Additional query words: OLAP
Keywords: kbbug kbnofix KB319634