HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

Discovering Applications, Backup Hosts and Hosts108
• Host IP/DNS Name: <IP Address>
• Database Server: <SQL Server Name>
• Port Number: <SQL Port #>
• Database Type: SQLSERVER
To add information for discovering a Microsoft SQL Server cluster:
1. 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. See 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 box, enter the IP address or DNS name of at least one of the
participating host nodes running Microsoft SQL Server cluster. You must provide the host name.
You cannot use localhost or parenthesis.
4. You can leave the Management IP/DNS Name box blank. When you leave the Management
IP/DNS Name box 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 box, enter the SQL database server name you want to monitor.
The SQL Server name would be one of the following:
• The name specified at the time the SQL server was installed
• The Microsoft SQL Network Name (the default instance)
For example, if a Microsoft SQL Server cluster instance called SQLCLUSTER is running on a 2
node Windows 2003 cluster (individual host node IP address being 192.168.2.10 and
192.168.2.11) at the default SQL port (1433) and shows the name of Microsoft SQL Network
Name within SQL Enterprise Manager / SQL Server Management Studio, the correct system
application discovery settings on the management server would be either of the following:
• Host IP/DNS Name: 192.168.2.10
• Database Server: SQLCLUSTER
• Port Number: 1433
• Database Type: SQLSERVER
Or
• Host IP/DNS Name: 192.168.2.11
• Database Server: SQLCLUSTER
• Port Number: 1433
• Database Type: SQLSERVER
6. In the Port Number box, enter the port that SQL is using.
To determine the correct SQL Port Number that the SQL Server is using, follow these steps:
Microsoft SQL Server 2000 Cluster