Analysis Services Configuration - Account Provisioning

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

Use the Analysis Services Configuration page of the SQL Server Installation Wizard to grant administrative permissions to users or services requiring unrestricted access to Analysis Services. SQL Server Code-Named “Denali” installations do 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 Installing PowerPivot for SharePoint.

Specify Analysis Services Administrators - You must specify at least one system 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.

  • To add the account under which SQL Server Setup is running, click the Add Current User button.

    Important note Important

    If you are installing PowerPivot for SharePoint using the New SharePoint Server option, you must add yourself as an Analysis Services administrator. This step allows SQL Server Setup, running under your Windows identity, to configure a SharePoint farm and deploy PowerPivot for SharePoint. Later, after PowerPivot software is installed, you can delegate this role to others and remove yourself from the SharePoint farm administrator group in Central Administration.

  • To add other users or services, click the Add… button and then enter the Windows domain user accounts for the person or service requiring administrative permissions.

  • To remove accounts from the list of system administrators, click Remove and then edit the list of users, groups, or computers that will have administrator privileges for the instance of SQL Server.

When you are finished editing the list, click OK, then verify the list of administrators in the configuration dialog box. When the list is complete, click Next.

Note Note

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 required 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).

Community Additions