Permissions on Database vs SSAS

Question

Hi,

If a SQL server abc123 has all installed SSIS, SSAS and SSRS.

Will sysadmin have access across all the data management tools?
If I want admin access only on SSAS then can it be granted?

Appreciate your time on this

Answer 1

Hi @SwatantraSingh-2674,

Welcome to Microsoft Q&A!

As an Analysis Services system administrator, you are in charge of granting membership to the server administrator role that conveys unrestricted access to operations on the server. This role has fixed permissions and cannot be customized. By default, members of the local Administrators group are automatically Analysis Services system administrators.

Roles are used in Analysis Services to manage model data access. There are two types of roles:

1. The server role, a fixed role that provides administrator access to an Analysis Services server instance.
2. Database roles, roles defined by model authors and administrators to control access to a model database and data for non-administrator users.

And which model do you used, tabula or multidimensional model?
If you are using Tabula Model, please refer to Roles and Lesson 11: Create Roles.
If you are using Multidimensional Mode, please refer to Roles and Permissions (Analysis Services) and Lesson 10 - Granting Process Database Permissions.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

All the applications have separate security models which are maintained separately.

For SSAS see: https://www.mssqltips.com/sqlservertip/2776/configuring-permissions-for-sql-server-analysis-services/