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

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

stora ge and access point resources for both MSDTC and SQ L server.

The installation of Microsoft SQL Server 2008 Enterprise with Service Pack1 is required. The

installa tion of Enterprise Edition with Service Pa ck 2 is optiona l. The installa tion instructions below

only cover Microsoft SQL Server 2008 Enterprise with SP1.

For additional information on service pack for Microsoft SQL Server 2008, refer to “How to obtain

the latest service pack for SQL Server 2008”,

http:/ / support.microsoft.com/ kb/ 968382.

Insta lling Microsoft Distributed Tra nsa ction Coordina tor a s a cluster

service

MS DTC c oordina tes distributed tra nsa ctions across a Windows fa ilover cluster. SQ L Server 2008

functiona lity can be adversely impa cted if MSDTC is not insta lled. In a n a ctive-active cluster MSDTC

must be insta lled as a cluster service. The implementa tion below insta lls one instance of MSDTC as a

clustered service in its own group. Performance is enhanced when MSDTC a nd SQ L Server run on the

sa me 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. Sta rt the Failover Cluster Manager. Fully expand the cluster tree (left pane) and then click

Services and Applications. You should see a display like Figure 5.

Fi g ure 5: Failover Cluster Manager Services and applications

3. Ri g h t-click on Services and Applications and then click Configure a Service or Application…. The

High Availability wizard starts. Follow the screen sequence below to completion.

a. In the Before You Begin: window, click Nex t.

b. In the Select Service or Application window, select Distributed Transaction

Coordinator (DTC), and then click Nex t.

c. In the Client Access Point window, enter the network name and IP address you

have provisioned for DTC. In this white paper, CMS-C2-DTC and 16.92.155.184

are used. Then, click

Nex t.