Microsoft KB Archive/296762

= FIX: DSO Allows Cube Role or Data Mining Role to Be Added Without a Corresponding Database Role =

Article ID: 296762

Article Last Modified on 11/21/2006

-

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.



RESOLUTION
To 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.



STATUS
Microsoft 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.

Additional query words: OLAP DSO

Keywords: kbbug kbfix kbssas800sp1fix KB296762

-

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

© Microsoft Corporation. All rights reserved.