HP ESO 3.0 User Guide

Figure 11 SQL Server Management Studio Login Properties window
Ensure HP ESO user accounts have Microsoft Analysis Services administrator privileges
To use HP ESO to access an Analysis Services instance to set parameters and optimize resources
based on the instance’s particular workloads, the 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 “Ensure
HP ESO user accounts have Microsoft SQL Server administrator privileges” (page 17)).
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 12 (page 19).
18 Using HP ESO