Add administrators

Configure Analysis Services Server Administrators

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Role membership is established when Analysis Services is installed. The user running the Setup program can add him or herself to the role, or add another user, when provisioning the server. You can modify role membership as a post-installation task using the following procedure.

  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 at the bottom of the page to add one or more Windows users or groups to the server role.

    Add users dialog box in management studio

At installation time, SQL Server Setup requires that you specify at least one user account as the Analysis Services system administrator.

By default, members of the local Administrators group are also granted administrative rights in Analysis Server. Although the local group is not explicitly granted membership in the Analysis Services server administrator role, local administrators can create databases, add users and permissions, and perform any other task allowed to system administrators. This behavior is configurable. It is determined by the BuiltinAdminsAreServerAdmins server property, which is set to true by default. You can change this property in SQL Server Management Studio. For more information, see Security Properties.

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

Add computer accounts

You can also use SQL Server Management Studio to configure computer accounts to be members of the Analysis Services administrators group.

  1. In the Select Users or Groups dialog, click Locations.

  2. Select the domain the computers that you want to add are a member of or select Entire directory and click Ok.

  3. Click Object Types.

  4. Select Computers and click Ok.

    add computer accounts as ssas administrators
  5. In the Enter the object names to select text box, type the name of the computer and click Check Names to verify the computer account is found in the current Locations. If the computer account is not found, verify the computer name and the correct domain the computer is a member of.

Community Additions

© 2016 Microsoft