Hp ProLiant DL980 G7 Server User Manual download pdf (Page 16)

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

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

16 Configuring user accounts to enable access to SQL Server and Analysis Services instances

1 2 ... 11 12 13 14 15 16 17 18 19 20 21 ... 81 82

No comments

Hp ProLiant DL980 G7 Server User Manual Page 16