HP ProLiant DL980 G7 Server - Manual (Page 15)

Figure 7 SQL Server Management Studio Login Properties window
Set user account privileges in Analysis Services security
To use HP ESO to access an Analysis Services instance to set parameters and optimize resources
based on the instance’s particular workloads, the Microsoft Analysis Services user account you
intend to use must be a member of the Microsoft Analysis Server Administrators group. To ensure
that an account is in the Administrators group, follow these steps:
1.
Open the Microsoft SQL Server Management Studio (see the instructions in step 1 of “Set user
account privileges in Database Engine security” (page 14) ).
2. Log in to an SQL Analysis Services instance using an account that is able to set permissions
of other accounts:
a.
Select Connect
→Analysis Services...
b. In the Connect to Server popup, select the server and click Connect.
3. In the Object Explorer panel on the left side of the page, right-click an instance and, from the
popup menu, select Properties, as shown in
Figure 8 (page 16) .
Set user account privileges in Analysis Services security 15