HP Storage Essentials V5.1 User Guide First Edition (T4283-96026, August 2006)

Discovering Applications, Backup Servers and Hosts122
c. Double-click Logins and view the list of users authorized to access the SQL Server.
d. If appiq_user is not listed, the management server is not able to discover the database.
6. To determine if the SQL Server is ready to accept connections from the management server:
a. Connect to the SQL Server installation through Query Analyzer using the account
“appiq_user” and the password “password.”
b. Create a sample ODBC datasource for the SQL Server installation using the appiq_user
account.
c. Click the Test button to test the datasource.
7. Repeat steps 4 through 6 for each SQL Server you want to manage.
Step B - Provide the Microsoft SQL Server Name and Port Number
The server name for the Microsoft SQL server and port number for managing a SQL database must
be provided in the following steps:
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