HP Storage Essentials NAS Manager Software - Manual (Page 138)

Discovering Applications, Backup Servers and Hosts 108
The port can be found in the following code:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
f. Select ORACLE from the Database Type menu.
g. Click OK.
5. Repeat Steps 4 and 5 for each node in the cluster.
Monitoring Microsoft SQL Server
To manage and monitor Microsoft SQL Servers, you must do the following:
• ” Step A - Create the APPIQ_USER for the SQL Server ” on page 108
• ” Step B - Provide the Microsoft SQL Server Name and Port Number ” on page 109
IMPORTANT: Make sure the Microsoft SQL server database is in “Mixed Mode authentication.” To
switch to mixed mode authentication, see ” Switching to Mixed Mode Authentication ” on page 108.
Switching to Mixed Mode Authentication
Microsoft SQL Server must be running in Mixed Mode Authentication. You can switch to Mixed
Mode Authentication as follows:
1. Open SQL Server Enterprise Manager (Start Menu > Programs > Microsoft SQL Server >
Enterprise Manager
).
2. Expand the tree-control until you can see your server.
3. Right-click the server name.
The SQL Server Properties (Configure) window appears.
4. Click the Security tab.
5. For “Authentication”, select SQL Server and Windows.
Step A - Create the APPIQ_USER for the SQL Server
The management server accesses SQL Server through the APPIQ_USER account. This account is
created when you run the CreateSQLServerAct.bat script on Microsoft Windows on the
computer running the SQL Server database you want to monitor. The account has create session
and select dictionary privileges to be used with the management server.
Keep in mind the following:
• The script must run under SA user.
• Obtain the SQL Server name before you run the script