HP ProLiant DL980 G7 Server - Manual (Page 7)

2 Installing HP ESO
Software Requirements
The following prerequisite software is required in order for HP ESO to function properly:
•
HP System Management Homepage (HP SMH), Version 6.0 or later
•
Any Internet browser supported by HP SMH (refer to your HP SMH documentation for more
information)
•
Microsoft .NET Framework, Version 2.0.50727 or later
•
Microsoft SQL Server 2008 Management Objects (or Microsoft SQL Server 2008 R2
Management Objects; or Microsoft SQL Server 2012 Management Objects)
•
HP Insight Management WBEM Providers (highly recommended)
Microsoft SQL Server Security Settings
The following steps are required for HP Enterprise SQL Optimizer to be able to access all SQL
Server instances in the system:
1.
Open the Microsoft SQL Server Management Studio.
2. Login to each SQL Server instance using an account that is able to set permissions of other
accounts.
3. Choose the following selections: Security
→ Logins → NT_AUTHORITY\SYSTEM → right click
and select Properties
→ Server Role → Select public, serveradmin and/or sysadmin roles.
4. Repeat the above steps for all SQL instances for ESO to optimize the resources across all SQL
instances as per their work load.
Figure 1 SQL Server Management Studio Window
Installing the Software
To install HP Enterprise SQL Optimizer, follow these steps:
1.
Login as Administrator on the target system.
2. Obtain the HP ESO installation file (filename: cpnnnnnn.exe) and either double-click on it, or
right-click and select Open.
3. The first installation window displays. Click Install to continue.
Software Requirements 7