Configuration steps prior to using hp eso – HP ProLiant DL980 G7 Server User Manual
Page 17
Configuration steps prior to using HP ESO
Prior to using HP ESO, you might need to perform the following:
•
To ensure that user accounts can access SQL Server instances, set the appropriate server roles
for these accounts, as described in
“Ensure HP ESO user accounts have Microsoft SQL Server
administrator privileges” (page 17)
.
•
To ensure that user accounts can access Analysis Services instances, ensure that each user
account is a member of Analysis Services Server Administrators, as described in
ESO user accounts have Microsoft Analysis Services administrator privileges” (page 18)
Ensure HP ESO user accounts have Microsoft SQL Server administrator privileges
To use HP ESO to access an SQL Server instance to set parameters and optimize resources based
on the instance’s particular workloads, the user account you intend to use must be assigned the
serveradmin and/or sysadmin SQL Server role. To assign SQL Server roles to an account, follow
these steps:
1.
Open the Microsoft SQL Server Management Studio. To open this page from Windows 2008
R2 and earlier, click Start
→Programs→Microsoft SQL Server Management Studio. To open
the page on Windows 2012, follow these steps:
In desktop mode
a.
Open the Start Menu charm on the left side of the desktop and change to tile mode.
b.
Click Microsoft SQL Server Management Studio.
In tile mode
Click Microsoft SQL Server Management Studio.
2.
Log in to an SQL Server instance using an account that is able to set permissions for the other
accounts.
3.
Follow these steps, as illustrated in
:
a.
In the Object Explorer pane on the left side of the page, select Security
→Logins.
b.
In the list of accounts under Logins, right click the account that is to be used in HP ESO
and select Properties.
c.
From the Login Properties page, select Server Roles.
d.
In the list of server roles, check the box of the serveradmin and/or sysadmin role. (The
Public role is checked by default.)
4.
Repeat steps 2 and 3 for all SQL Server instances.
Configuration steps prior to using HP ESO
17