•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
108 Discovering Applications, Backup Hosts and Hosts