Installing HP Insight Software 6.1 Update 1 on Windows Server 2008 R2 Failover Clusters with SQL Server 2008 for high availability

25
Figure
7
:
Failover Manager after creating cluster service and resources for
Systems Insight Manager
a
nd Insight Software
Install Insight Software prerequisites
Complete the following configuration items before install
ing
Insight Software.
Verify the SQL Server clustered instance and determine port number in use
If you did not verify the clustered SQL S
erver instance that Insight software
is to
use,
move
the SQL
Server application to its alternate node and then back to its current node.
Starting with the 6.0 release, Insight Software does not allow dynamic port numbers to be used with
database named inst
ances. By default, named instances in SQL server 2008 are configured to use
dynamic ports. If SQL Server is configured to use dynamic ports, this setting must be changed.
By default
,
the unnamed database instance listens on port 1433. The SQL Browser uses
port 1434.
Ports 1435 and incrementally higher are often good choices for named instance static port numbers.
To determine and adjust the TCP/IP port used by the SQL Server database instance:

On the node owning the SQL Server resources, run
SQL Server Conf
iguration Manager
by selecting
Start

All Programs

Microsoft SQL Server 2008

Configuration Tools

SQL Server
Configuration Manager
from the menu
.

In the left pane
,
expand
SQL Server 2008 Network Configuration
.