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

18
Figure
6
:
Microsoft Distributed Transaction Coordinator service in Failover
Cluster Manager
4.
In the center pane under the heading
Microsoft Distributed Transaction Coordinator
, right
-
click the
service name
MSDTC
-
cms
-
c2
-
dtc
,
shown above,
and then click
Properties
.
Select
the
Advanced
Policies
tab and ensure that
both cluster node
s are selected
under
Possible Owners
.
For additional information on DTC refer to:
1.
Requirements for Creating an MS DTC Resource in a Failover Cluster
,
http://technet.microsoft.com/en
-
us/library/cc770748(WS.10).aspx
.
2.
Understanding MS DTC Resources in Windows Server 2008 Failover Clusters
,
http://technet.microsoft.com/en
-
us/libra
ry/cc730992(WS.10).aspx
.
3.
Administering Distributed Transactions
,
http://technet.microsoft.com/en
-
us/library/cc755134(WS.10).aspx
.
Install Microsoft SQL Server 2008 Enterprise SP1
as a cluster service
Microsoft SQL Server 2008 provides SQL database services to Insight Software applications. The
Enterprise Edition with Service Pack 1 is required. A separate install is
required
for each node.
This
white paper documents the
Add Node
a
lternative for installing SQL server 2008, the simpler choice
for a two node clust
er. The other option is called
Adv
anced/Enterprise installation
.