HP ProLiant DL980 G7 Server User Manual
Page 14
3 Configuring user accounts to enable access to SQL Server
and Analysis Services instances
Prior to using HP ESO, ensure that the appropriate user accounts can access SQL Server and
Analysis Services instances:
•
Set user account privileges in Database Engine security, as described in
privileges in Database Engine security” (page 14)
•
Set user account privileges in Analysis Services security, as described in
privileges in Analysis Services security” (page 15)
Set user account privileges in Database Engine security
To use HP ESO to access an SQL Server instance to set parameters and optimize resources based
on the instance’s particular workloads, the Microsoft SQL Server 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.
14
Configuring user accounts to enable access to SQL Server and Analysis Services instances