FIX: DSO Allows Cube Role or Data Mining Role to Be Added Without a Corresponding Database Role (296762)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q296762
BUG #: 11535 (Plato7.x)
SYMPTOMS
Analysis Services provides the Decision Support Object (DSO) object model for managing Analysis Services. Although not intended by design, DSO allows you to add cube roles or data mining model roles without a corresponding database role.
RESOLUTIONTo resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
WORKAROUND
Always create a database role first and then add this role to the cube or data mining model.
STATUSMicrosoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.MORE INFORMATION
Although Analysis Manager uses DSO internally, when a user tries to add a cube role or data mining role, Analysis Manager recognizes this and creates the database role first before adding the role to a cube or a data mining model. Therefore, this problem is not noticed with Analysis Manager.
| Modification Type: | Minor | Last Reviewed: | 4/24/2003 |
|---|
| Keywords: | kbBug kbfix kbssas800sp1fix KB296762 kbAudDeveloper |
|---|
|