• Article

Grant Server-wide Administrative Access (Analysis Services)

Members of the server administrator role within an instance of Microsoft SQL Server Analysis Services have unrestricted access to all Analysis Services objects and data in that instance. A member of the Analysis Services server role can add Microsoft Windows users and groups to the Analysis Services server role. A user must be a member of the Analysis Services server role to perform any server-wide task, such as creating a database, modifying server properties, or launching a trace (other than for processing events).

Procedure

To modify the members of the server administrator role for an instance of Analysis Services

  1. In SQL Server Management Studio, connect to the instance of Analysis Services, and then right-click the instance name in Object Explorer and then click Properties.

  2. Click Security in the Select a Page pane, and then click Add to add one or more Windows users or groups to the server role.

Note

In contrast with previous releases of SQL Server, members of the local Administrators group are no longer automatically assigned to the Analysis Services server administrator role. You must now specify which Windows user or group accounts have administrative permissions during Setup when Analysis Services is first configured, or after Setup using the steps provided in this topic.

You can also manage server roles by using Analysis Management Objects (AMO). For more information, see Analysis Management Objects (AMO).