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 Server Name field, type the SQL database 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:

110 Discovering Applications, Backup Servers and Hosts