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

17
Install the
Microsoft
SQL
Server
2008
Enterprise
A
c
l
ustered
instan
c
e of Microsoft
SQL
Server 20
0
8 Enterprise is
r
e
q
u
i
r
ed for Insi
g
ht Software
components
to
beco
m
e highly
ava
i
lable.
If you alrea
d
y have installed
a suitable
named instance of
M
i
cr
o
soft S
Q
L Server 20
0
8 Enterprise, y
o
u may skip to
Install
Insight
Software
on
t
he
C
l
uster
a
n
d
specify
this
instan
c
e
when
prompted.
In this section, Microsoft Distributed
Transac
t
ion Coordinator (MSDTC) and Mic
r
osoft SQL Ser
v
er
2008
are i
n
s
t
alled. It is assumed that you already
have a worki
n
g two
-
no
d
e c
l
us
t
er with available
storage
and
ac
cess point
resourc
e
s for both
MSD
T
C and SQL server.
Install
Microsoft
Distributed
Transacti
o
n
Coordinator
as
a
cluster
service
MSDTC c
o
or
d
inates distributed
transacti
o
ns acr
o
ss a Windo
w
s fai
l
over c
l
us
t
er. SQL Serv
e
r 2
0
08
f
u
n
c
tionality
can
be
adversely
impacted
if
MSDTC
is
not installed.
In an a
c
tive
-
a
c
tive
c
luster
M
S
D
T
C
m
u
st
be
installed
as a
c
l
u
ster
servi
c
e.
T
h
e impleme
n
tation
below installs
one instance
of MS
D
TC
as a
clustered serv
i
c
e in i
t
s own
group. Pe
r
fo
r
mance is en
h
anced when
MSD
T
C and SQL Server
ru
n on the
same
c
l
u
s
ter
node;
but this is not require
d
.
Install MS
D
T
C as a
c
l
u
stered
service:
1.
With both cluster nodes online, log into a
sys
t
em
u
si
n
g the SQL/IS
A
dministrator
credentia
l
s.
2.
Start
the
Failover Cluster Manager
. Fully
expand the
c
l
uster tree (left
pane) and then
c
lick on
Services and Applications
.
You s
h
o
u
ld s
e
e a display li
k
e Fi
g
u
re 5:
Figure
5:
Failover
Cluster
Manager
Services
and
a
p
plications
3.
Righ
t
-
c
l
i
c
k on
Services and Applications
and
then
click
Configure a
Service or
Applicatio
n
…. The
High Availab
i
lity
wizard st
a
rts. Foll
o
w the screen
sequen
c
e below
to
c
ompletion.
(The
screen name
is in quo
t
es.)
a.
“Bef
o
re Y
o
u
B
egin:”
N
e
xt
.
b.
“Select S
e
rvice or Appl
i
c
at
i
on:” sel
e
ct
D
i
stributed Tra
n
saction C
o
or
d
inator (DTC)
and
cli
c
k
N
ext
.
c
.
“Client Access Point:”
Enter the network name a
n
d IP
you have provisioned
for
D
TC. In this
white paper cms
-
c2
-
d
t
c and 16.92.155
.
184 are use
d
. Then click
N
ext
.