Analysis Services Configuration - Account Provisioning

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 PowerPivot for SharePoint, be sure to grant administrative permissions to SharePoint farm administrators or service administrators who are responsible for a PowerPivot server deployment in a SharePoint Server 2010 farm. For more information about PowerPivot service installation and service account requirements, see Install SQL Server BI Features with SharePoint (PowerPivot 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.


User Account Control (UAC) is a Windows security feature that requires an administrator to specifically approve administrative actions or applications before they are allowed to run. Because UAC is on by default, you will be prompted to allow specific operations that require elevated privileges. You can configure UAC to change the default behavior or customize UAC for specific programs. For more information about UAC and UAC configuration, see User Account Control Step by Step Guide and User Account Control (Wikipedia).

See Also

Configure Service Accounts (Analysis Services)
Configure Windows Service Accounts and Permissions