向 Analysis Services 实例授予服务器管理员权限Grant server admin rights to an Analysis Services instance

适用于: 是SQL Server Analysis Services没有Azure Analysis ServicesAPPLIES TO: yesSQL Server Analysis Services noAzure Analysis Services

对于 Analysis ServicesAnalysis Services 实例中的所有 Analysis ServicesAnalysis Services 对象和数据,该实例中的服务器管理员角色的成员具有无限访问权限。Members of the Server administrator role within an instance of Analysis ServicesAnalysis Services have unrestricted access to all Analysis ServicesAnalysis 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).

安装 Analysis ServicesAnalysis Services 时将建立角色成员身份。Role membership is established when Analysis ServicesAnalysis Services is installed. 运行安装程序的用户可以将自己添加到该角色,或添加其他用户。The user running the Setup program can add him or herself to the role, or add another user. 必须指定至少一个管理员,安装程序才能继续。You must specify at least one administrator before Setup will allow you to continue.

默认情况下,还将为本地 Administrators 组的成员授予 Analysis Server 中的管理权限。By default, members of the local Administrators group are also granted administrative rights in Analysis Server. 虽然未显式授予本地组 Analysis ServicesAnalysis Services 服务管理员角色中的成员身份,但是本地管理员可创建数据库、添加用户和权限以及执行系统管理员允许的任何其他任务。Although the local group is not explicitly granted membership in the Analysis ServicesAnalysis Services server administrator role, local administrators can create databases, add users and permissions, and perform any other task allowed to system administrators. 管理员权限的隐式授权可配置。The implicit granting of administrator permissions is configurable. 它由 BuiltinAdminsAreServerAdmins 服务器属性确定,该属性默认情况下设置为 trueIt is determined by the BuiltinAdminsAreServerAdmins server property, which is set to true by default. 您可在 SQL Server Management StudioSQL Server Management Studio中更改此属性。You can change this property in SQL Server Management StudioSQL Server Management Studio. 有关详细信息,请参阅 Security PropertiesFor more information, see Security Properties.

安装后,可以修改角色成员身份,以添加需要对该服务拥有完全权限的任何其他用户。Post-installation, you can modify role membership to add any additional users who require full rights to the service. 您还可以使用分析管理对象 (AMO) 来管理服务器角色。You can also manage server roles by using Analysis Management Objects (AMO). 有关详细信息,请参阅使用分析管理对象 (AMO) 进行开发For more information, see Developing with Analysis Management Objects (AMO).

备注

Analysis ServicesAnalysis Services 提供粒度越来越细的角色在服务器、数据库和对象级处理和查询的进度。provides a progression of increasingly granular roles for processing and querying at server, database, and object levels. 有关如何使用这些角色的说明,请参阅角色和权限 (Analysis Services)See Roles and Permissions (Analysis Services) for instructions on how to use these roles.

修改服务器角色成员身份Modify Server Role Membership

  1. SQL Server Management StudioSQL Server Management Studio 中,连接到 Analysis ServicesAnalysis Services 实例,在对象资源管理器中右键单击实例名称,然后单击“属性”。In SQL Server Management StudioSQL Server Management Studio, connect to the instance of Analysis ServicesAnalysis Services, and then right-click the instance name in Object Explorer and then click Properties.

  2. “选择页” 窗格中单击 “安全性” ,然后单击页底部的 “添加” 以将一个或多个 Windows 用户或组添加到服务器角色中。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.

    在 management studio 中的添加用户对话框Add users dialog box in management studio

添加计算机帐户Add computer accounts

可以使用 SQL Server Management StudioSQL Server Management Studio 让计算机帐户成为 Analysis ServicesAnalysis Services 管理员组的成员。You can also use SQL Server Management StudioSQL Server Management Studio to make a computer account a member of the Analysis ServicesAnalysis 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.

    将计算机帐户添加为 ssas 管理员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.

NT Service\SSASTelemetry 帐户NT Service\SSASTelemetry account

“NT Service/SSASTelemetry”是在安装过程中创建的低特权计算机帐户,专门用于运行客户体验改善计划 (CEIP) 服务的 Analysis ServicesAnalysis Services 实现。NT Service/SSASTelemetry is a low-privileged machine account created during setup and used exclusively to run the Analysis ServicesAnalysis Services implementation of the Customer Experience Improvement Program (CEIP) service. 此服务需要 Analysis ServicesAnalysis Services 实例的管理员权限来运行多个发现命令。This service requires admin rights on the Analysis ServicesAnalysis Services instance to run several discover commands. 有关详细信息,请参阅 Customer Experience Improvement Program for SQL Server Data ToolsMicrosoft SQL Server Privacy StatementSee Customer Experience Improvement Program for SQL Server Data Tools and Microsoft SQL Server Privacy Statement for more information.

另请参阅See Also

授予对对象和操作的访问权限 (Analysis Services) Authorizing access to objects and operations (Analysis Services)
安全角色(Analysis Services - 多维数据)Security Roles (Analysis Services - Multidimensional Data)