Managing instance-level administrative security
Each Analysis Services instance has one server role reserved for administrators. All members of this role have unrestricted access to all objects on the instance. Membership in the administrator role is mandatory to perform the following operations:
Create and drop databases
Collect traces against multiple databases on the same instance in a single trace
Stop/restart the instance
Backup/restore databases
Modify server configuration settings
Grant server-level administrator permissions
Detach/attach databases
Synchronize databases (requires administrative permissions to both source and target instances)
How to do it...
To add members to the server administrator role, perform the following steps:
Connect to the SSAS instance to which you have administrative access using SSMS, right-click on the instance, and choose Properties.
Navigate to the Security tab of the resulting Analysis Services Properties dialog box. Click on Add, enter the domain and login name...
