Roles in Analysis Services

Question

Roles in Analysis Services

antonela

Ten Centuries

Points: 1007
More actions
February 22, 2006 at 7:50 am

#111266

I created a cube in Analysis Services.
It contained a dimension "Agenti" and a user must see only a member of this dimension. The user isn't an OLAP Administrator, but is a member of Domain Admins. I created a role in Manage Roles of Analysis Services and I authorized him to see only the member with his name. But he logon and see all the cube (there are the .htm pages with pivot table) Why?
It isn't the first time I do this, on this server doesn't function properly (windows small business server, sql server 2000)
Thanks
Anto

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 1

By default, local administrators group are included as Olap Administrators. You can exclude Domain Admins from local administrators or, if you have SP4, you can modify the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion\ExcludeMachineAdminFromOLAPAdmin

and set the value to 1 to exlude local admins from Olap Admins.

antonela Ten Centuries Points: 1007 More actions · Answer 2

I installed SP4 (Sql Server and AnServ - 2039) but I don't have the key ExcludeMachineAdminFromOLAPAdmin.How is it possible?

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 3

I think it's not created by default. You can create it with a type DWORD.

You can read more here: http://www.support.microsoft.com/default.aspx/kb/834419/en-us/

and here: http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql2k_anservregsettings.asp?frame=true&_r=1

antonela Ten Centuries Points: 1007 More actions · Answer 4

ok I did it...

But in this case I am not authorized to see anything. When I tried to open the Pivot Table, the error occurs "Database doesn't exist", because the user can not connect to Analysis Services.