Microsoft KB Archive/319634

= BUG: User Cannot Create or Process an OLAP Database Even if the User is a Member of the OLAP Administrators Group =

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.

