Installing and upgrading to HP Insight Software 6.2 on Windows Server 2008 R2 Failover Clusters with SQL Server 2008 for high availability

25
Figure
7:
Failover
Manager
a
fter
creating
c
l
uster
se
r
vi
c
e
and
resourc
e
s
f
or
HP
S
I
M
and
Insight
So
f
t
ware
Install
Insight
Software
prerequisites
Comple
t
e the
following
configura
t
ion ite
m
s b
e
fo
r
e
start
i
ng to install I
n
sight Sof
t
wa
r
e.
Verify the SQL Server
clustered instan
c
e and
det
e
rmine port nu
m
b
e
r in use
If you did
not just now verify the
c
lustered
SQL Server instance
that
Insight softwa
r
e will use, do
so
now by moving the SQL Server
application to its alternate
node and
then ba
c
k to
its
c
u
rrent no
d
e.
Starting
with the 6.0 rele
a
s
e, Insight Sof
t
ware does
not allow dynamic port
nu
m
b
ers to be used
with
database
named instances.
By default,
named ins
t
ances in SQL
server 2008 are
configured to
use
dynamic ports.
If SQL Server is
c
onfig
u
r
ed
to
u
se dynamic ports,
this
setting
now m
u
st
be
c
hanged.
By default
the unnamed database
instance lis
t
ens on
p
ort 1433.
T
h
e SQL Browser uses port
1434.
Ports 1
4
35 and incre
m
en
t
ally higher a
r
e often
g
ood
c
hoi
c
e
s for named instance static port numbers.
To determine
and adjust the T
C
P/IP port used by the SQL Server
d
a
tabase
instan
c
e:
•
On the node
owning t
h
e SQL Server resources, run
SQL Server C
o
nfiguration Manager
(Start

All
Progra
m
s

M
i
cr
o
soft S
Q
L Server 20
0
8

Co
n
fi
g
ur
a
t
i
on Too
l
s

S
QL Serv
e
r C
o
nfi
g
uration
Manager).
•
In the left pane expand
SQL
Server 2008
Ne
t
work Configuratio
n
.