Set user account – HP ProLiant DL980 G7 Server User Manual
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
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
16
Configuring user accounts to enable access to SQL Server and Analysis Services instances