Installation Manual

HP Storage Essentials SRM 6.0 Installation Guide 319
Provide the Microsoft SQL Server Name and Port Number for a Cluster
The server name for the Microsoft SQL Server and port number for managing a Microsoft SQL
Server cluster database must be provided in the following steps:
IMPORTANT: If you have name resolutions issues, your server may be discovered; however, your
applications will not be discovered. You can address 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 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