BUG: User Cannot Create or Process an OLAP Database Even if the User is a Member of the OLAP Administrators Group (319634)
The information in this article 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.
CAUSEThe 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 INFORMATIONIf 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
| Modification Type: | Minor | Last Reviewed: | 4/29/2003 |
|---|
| Keywords: | kbbug kbnofix KB319634 kbAudDeveloper |
|---|
|