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

Storage Essentials 5.1 User Guide 131
IMPORTANT: You must provide the host name in the Host IP/DNS Name field. You cannot use
localhost or parenthesis.
If you have name resolutions issues, your server may be discovered; however, your applications will
not be discovered. You can addressed the name resolution issues by adding entries within the hosts
file on the management server for the systems in question.
When configuring the System Application Discovery Settings for SQL servers, the following needs to
be specified as described in the steps within this section:
• Host IP/DNS Name : <IP Address>
• Database Server : <SQL Server Name>
• Port Number : <SQL Port #>
• Database Type : SQLSERVER
To add information for discovering a SQL server:
1. Do one of the following:
• Discovery from HP SE - Select Tools > Storage Essentials > Home > Discovery >
Setup . Then, click the Applications tab.
• Discovery from HP SIM - Select Options > Protocol Settings > Storage Essentials >
System Application Discovery Settings. To select a target, you must have at least one
element designated as a server, workstation or desktop. If you see the message, “No Targets
Currently Selected,” change your element from unknown to either a server, workstation or
desktop. Refer to the documentation for HP Systems Insight Manager. Select a target, and
then, click Run Now.
2. Click the Create button for the Database Information table.
3. In the Host IP/DNS Name field, type the IP address or DNS name of the host running SQL
Server.
4. You can leave the Management IP/DNS Name field blank. This field is for Oracle clusters.
When you leave the Management IP/DNS Name field blank the management server
automatically lists the DNS name or IP address of the host under the Host IP/DNS Name
column and Management IP/DNS Name column.
5. In the Database Server field, type the SQL database server name you want to monitor.
The SQL Server name is either the Windows system name (default) or the name specified when
the SQL server was installed.
SQL Enterprise Manager displays the SQL server name as one of the following:
• As the name specified at the time the SQL server was installed.
• As the Windows system name (Windows 2000)
• As the local name (Windows 2003)
For example, if a Windows 2003 server called SQLTEST has an IP address of 192.168.2.10
with the default SQL port (1433) and shows the name of (local) within SQL Enterprise Manager,
the correct system application discovery settings on the management server would be the
following: