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

19
Install
Microsoft
SQL
Server
2
008
Enterprise
SP1
as
a
cluster
service
Mi
c
rosoft SQL Server 2008
provides SQL database
ser
v
ices to Ins
i
ght
Software
applications.
T
h
e
Enterprise Ed
i
tion with Serv
i
c
e Pack 1
i
s requi
r
ed. A separate
install is done for e
a
c
h
node, see
below. (This
white paper
documents the “Add
Node”
alternative
for installing
SQL ser
v
er 2008,
the
simpler
cho
i
ce for a two node c
l
us
t
er. The other o
p
tion
is
c
a
lled
“Advanced/E
n
terprise i
n
stalla
t
ion.”)
Crea
t
e a slipstream distribution
Install from a “slipstream”
distri
b
ution of M
i
cr
o
soft S
Q
L
Server 20
0
8
and SP1. There are kn
o
wn
problems
installing
and
u
pdating
f
r
om the original
RTM distri
b
ution.
R
efer to the following resources
for inst
ru
ctio
n
s on how to
c
reate a slipst
r
eam distribu
t
i
on:
1.
“Creating a
merged (slipstream
e
d) drop
containing
S
QL Server 2
0
08 RTM + Se
r
vice P
a
ck 1,”
http://blogs.msdn.com/b/petersad/archive/2
0
09/
0
2/25/sq
l
-
ser
v
er
-
2
00
8
-
c
r
ea
t
ing
-
a
-
m
er
g
ed
-
slisptream
-
drop.aspx
.
2.
“SQL Server
2008
Slips
t
ream Frequen
t
ly
Asked Ques
ti
ons,”
http://blogs.msdn.com/b
/
peter
s
ad/a
r
chive/2
0
09/
0
4/24/sq
l
-
ser
v
er
-
2
00
8
-
s
l
ips
t
ream
-
f
r
equent
l
y
-
as
k
e
d
-
questions.aspx
.
3.
“How to
u
pdate
or slipstream
an
installation
of SQL
S
erver 2008,”
http://support.microsoft
.
c
om/kb/955392
.
Alternative method for launching
t
h
e SQL Server 2008 installer
HP
en
c
o
untered
a
difficulty,
docum
e
n
t
ed
by Micr
o
soft
as “Error me
s
sage w
h
en y
o
u install S
Q
L Server
2008 on a Windo
w
s Se
r
ver 200
8
-
based cluster: T
h
e c
l
u
s
t
er eit
h
er has not been
verif
i
ed or there are
erro
r
s or fai
l
ures in the ve
r
i
f
ication
r
eport
.
”
Refer to K
B
953
7
48 or SQL server bo
o
k
s on
l
ine, see
http://support.microsoft
.
c
om/kb/953748
.
This condition
occurs during
SQL Ser
v
er 20
0
8 inst
a
llation
after you ha
v
e run c
l
uster
v
erificat
i
on
wi
t
h
no
erro
r
s or
failu
r
es
bei
n
g reported
and effe
c
tively
halts
your i
n
stallat
i
on.
If this
o
c
c
u
rs in
yo
u
r install
a
tion,
the
workaro
u
nd
is to invoke the SQL Server 2008
installer
from the
c
ommand
prompt
as
des
c
ribed
her
e
. Navigate to the direc
t
ory that contai
n
s se
t
u
p
.
exe for the
S
QL
Server 2
0
08
slipst
r
eam dis
t
ribut
i
on. Then
use o
n
e of t
h
e foll
o
wi
n
g commands to
s
tart the SQL Server
2008 i
n
stalle
r
.
1.
For installa
t
i
o
n on the first
node:
setup /
SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster
2.
For installation
on the se
c
o
nd node:
setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode
Do not use this method to bypass actual
c
luster verification errors or
f
ailures.
Install
Mic
r
o
s
o
ft
SQL Server 2
0
08
Ent
e
rpr
i
se
SP1 on the prim
a
ry s
y
stem
Not
e
:
Depending
on
th
e invocation
method
u
s
ed,
the
ord
e
r
of
the initial
ins
t
aller
screens
may
d
i
ff
e
r
slight
l
y.
The
se
q
uen
c
e below
r
e
f
l
ects
c
o
mm
a
nd
li
n
e
invocation.
The
SQL
Server
install
e
r
screen
n
a
mes
a
r
e
given
in
quot
e
s,
follow
i
ng e
a
ch
s
t
ep
number
b
e
lo
w
.