Monday, March 26, 2012

Rights to access an external 2005 analysis server

Hi,

I just wanted to know what rights as a user one would need in order
to edit/process a cube which is on an external 2005 Analysis Server.
Right now my user is part of the SQLServer2005MSOLAPUser$Machine
Name$MSSQLSERVER group on this server.
I am able to connect to thsi server through SQL Server Management
Studio., but I dont see any analysis services databases under it.

Thanks

In AS 2005 you manage security through the database roles, not by OS security groups. This is change from AS2000. I am guessing you are current AS2000 user and trying apply the same logic.

To grant processing rights. Create a database role, add your user and grant the role youve created processing rights to the cube. This should be pretty straightforward.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment