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

17
In this section Microsoft Distributed Transaction Coordinator (MSDTC) and Microsoft SQL Server 2008
are installed. It is assumed that you already have a working two
-
node cluster with available storage
a
nd access point resources for both MSDTC and SQL server.
Install Microsoft Distributed Transaction Coordinator as a cluster service
MSDTC coordinates distributed transactions across a Windows failover cluster. SQL Server 2008
functionality can be adversely
impacted if MSDTC is not installed. In an active
-
active cluster MSDTC
must be installed as a cluster service. The implementation below installs one instance of MSDTC as a
clustered service in its own group. Performance is enhanced when MSDTC and SQL Serve
r run on the
same cluster node; but this is not required.
Install MSDTC as a clustered service:
1.
With both cluster nodes online, log into a system using the SQL/IS Administrator credentials.
2.
Start the
Failover Cluster Manager
. Fully expand the cluster tree
in the left pane
and then click
Services and Applications
.
Figure
5
:
Failover Cluster Manager Services and applications
3.
Right
-
click
Services and Applications
and then click
Configure a Service or Application
…. The
High
Availability
wizard starts.
Complete the following screen sequence:
a.
Before You Begin
:
click
Next
.
b.
Select Service or Application
: select
Distributed Transaction Coordinator (DTC)
and
then
click
Next
.
c.
Client Access Point
: Enter the network name and IP you have provisioned for DTC. In
this white
paper
cms
-
c2
-
dtc
and
16.92
.155.184
are used, and t
hen click
Next
.
d.
Select Storage
: The three available disks are listed.
Select the
disk you have provisioned for
DTC. This white paper uses
c2_msdtc
, and then
click
Next
.
e.
Confirmation
: Check and then click
Next
.
f.
Configure High Availability
: Observe progress indicators. No response needed.
g.
Summary
: If desired
,
click
View Report …
.
Review
and then click
Next
.