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

7
•
Fi
g
u
re 1 s
ho
ws the Fai
l
over C
l
us
t
er wi
t
h a virtual se
r
ver for Insight
Software and another for
clustered
SQL Server 20
0
8. In this
docu
m
ent, the prefe
r
red sys
t
em for
running I
n
si
g
ht Software is
called the pr
i
mary system. The s
y
stem on
which
SQL
S
erver 2
0
08
n
ormally ru
n
s
i
s called the
s
e
condary s
ys
tem.
Figure
1:
Relati
on
ships
amo
n
g
HP
SIM,
Ins
i
ght
Sof
t
ware,
SQL
Server
2008,
and
t
he cluster
disks
F
a
ilov
e
r
Cluste
r
virtu
a
l
s e r v
e
r
IP Addres
s
:
1
6
.9
2
.
15
5
.
1
83
I
n
s
i
g
h
t
Sof
t
w
a
r
e
vir
t
u
a
l
s
e
rver
H
P
S
I
M
I
P
a
d
d
r
es
s
:
1
6
.
9
2.
1
5
5
.
186
S
Q
L Server
2
0
08
v ir
t
u
a
l
s
e
r v e r
I
P
a
d
d
r
es
s
:
1
6
.9
2
.15
5
.185
L
o
ca
l
conne
c
t
ion
R
em
o
t
e
c
onne
c
t
ion
Failover
C
l
u
s
t
e
r
p r im a r y
s
y s
t
e m
I
P
A
d
d
r
es
s
:
1
6
.9
2
.
1
5
5
.179
F
a
ilover
C
lu
st
e
r
s
e
c
o n
d
a
r y
s y
s
te m
I
P
A
d
d
r
es
s
:
1
6.
9
2.
1
5
5
.
1
8
0
S:
o
n
sh
a
re
d
s
t
ora
ge
V:
o
n
sh
a
re
d
s
t
orage
SQL
Serv
e
r
i
n
st
a
n
c
e
fil
e
s
I
n
sight
S
oftw
a
re f
i
l
e
s
The cluster
m
onitors the services belo
n
g
i
ng to Insight
Software
and
Microsoft
SQL
Server
2008.
Should a service fail, the
cluster au
t
omatically
pre
s
en
t
s that service’s
s
hared stora
g
e
to the other
system, mov
e
s the virtual
s
erver, and re
s
tarts the failed
serv
i
c
e the
r
e.
Getting
started
T
his
white p
a
per doc
u
ments how to inst
a
ll Insight Sof
t
ware on a new two
-
no
d
e M
i
cr
o
soft Fa
il
over
Cluster
.
2
The major
st
ep
s are:
•
Set up the fai
l
over envi
r
o
n
ment
•
Install SQL Server 20
0
8 on the c
l
us
t
er
•
Install and
validate
Insight
S
oftware on the
c
l
u
s
ter
If a
c
lustered
Mi
c
rosoft
SQL Server 20
0
8 Enterprise
named instance
exists
on a different
c
l
u
ster
than
the one on which Insight
S
oftware is to run, you m
a
y u
s
e this instan
c
e and skip
the installation
of a
new SQL
Ser
v
er 2008
inst
a
n
c
e on the Insight Software
c
luster.
In this
c
ase
you may
also
skip
the
allo
c
ation
of the
a
c
cess point
IP addresses
and
n
e
twork names, and
t
he shared dis
k
s for Mi
c
rosoft
SQL Server
a
nd for Microsoft Distributed
Transac
t
ion
Coordinator.
2
W
i
n
d
o
w
s Server 2
0
08 R2
E
nterp
r
i
s
e s
u
p
p
orts
F
a
i
l
o
v
er
C
l
u
s
ters
w
i
t
h
u
p
t
o
1
6
n
o
d
es.
T
he
nu
m
b
er
o
f su
pp
o
rte
d
n
o
d
es
i
n a
c
l
u
s
t
er
v
a
r
i
es
b
y o
p
era
t
ing
sys
t
em v
e
rsi
o
n. For
d
et
a
i
l
s,
n
a
vi
g
a
te
to
http
:
//s
u
p
port.
m
icrosoft
.
com
,
a
n
d
se
arch
f
or
“M
axi
m
um
n
u
m
b
er
of
su
p
p
or
t
ed
n
od
es
i
n
a cl
u
ster.”