Granting Server-Wide Administrative Permissions

Members of the server role within an instance of Microsoft SQL Server 2005 Analysis Services (SSAS) 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 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:
By default, the members of the Administrators local group are members of the Analysis Services server role. However, their membership in this server role does not appear in the user interface.

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