Analysis Services Configuration - Account Provisioning
Applies To: SQL Server 2016
Use this page to set the server mode, and to grant administrative permissions to users or services requiring unrestricted access to Analysis Services. Setup does not automatically add the local Windows Group BUILTIN\Administrators to the Analysis Services server administrator role of the instance you are installing. If you want to add the local Administrators group to the server administrator role, you must explicitly specify that group.
If you are installing Power Pivot for SharePoint, be sure to grant administrative permissions to SharePoint farm administrators or service administrators who are responsible for a Power Pivot server deployment in a SharePoint Server 2010 farm. For more information about Power Pivot service installation and service account requirements, see Install SQL Server BI Features with SharePoint (Power Pivot and Reporting Services).
Server Mode - The server mode specifies the type of Analysis Services databases that can be deployed to the server. Server modes are determined during Setup and cannot be modified later. Each mode is mutually exclusive, which means that you will need two instances of Analysis Services, each configured for a different mode, to support both classic OLAP and tabular model solutions.
Specify Administrators - You must specify at least one server administrator for the instance of SQL Server. The users or groups that you specify will become members of the server administrator role of the Analysis Services instance you are installing. These must be Windows domain user accounts in the same domain as the computer on which you are installing the software.