2

I have an user called mycompany\aives that is not listed in the list of administrators in the SSAS, not belong to any of the AD (active directory) groups listed there,

however,

he can connect to the cubes in this server (called SASBI01).

if you see , however, the second picture, mycompany\aives is listed as one of the administrators on the box (SASBI01)

Where does it say that the administrators on the box can (or not) connect to the cubes?

How can I find out (preferably via script), a list of users that can connect to the cubes and their permissions?

enter image description here

enter image description here

Improve this question

1 Answer 1

Reset to default
3

Check the server property BuiltinAdminsAreServerAdmins. Till SQL Server 2014 it defaults to true. Not sure if it will be changed in 2016 (hopefully).

Link: https://msdn.microsoft.com/en-us/library/ms174561(v=sql.120).aspx

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.