Portal GuilleSQL - English corner

How to configure the Distributed Transaction Coordination (DTC) on a Windows Server 2008 R2 Failover Cluster


One task to do after installing and configuring a Windows Server 2008 R2 Failover Cluster is configuring the Distributed Transaction Coordinator (DTC) for High Availability. This post explains step by step how to configure the Distributed Transaction Coordinator (DTC) for High Availability on Windows Server 2008 R2 Failover Cluster.

We have a Windows Server 2008 R2 Failover Cluster having two Nodes available to make a SQL Server 2008 R2 Cluster installation, configured for Node and Disk Majority using a Quorum Disk. There is no Application or Resource Group configured yet, and we have three shared disks available on the Failover Cluster to be used by DTC and other applications.

We have a Windows Server 2008 R2 Failover Cluster having two Nodes, configured for Node and Disk Majority using a Quorum Disk. There is no Application or Resource Group configured yet, and we have three shared disks available on the Failover Cluster to be used by DTC and other applications.

To configure MS DTC on Windows Server 2008 R2 Failover Cluster, you should use the Failover Cluster Manager administrative tool. Right click on Services and applications, and then click Configure a Service or Application.

To configure MS DTC on Windows Server 2008 R2 Failover Cluster, you should use the Failover Cluster Manager administrative tool. Right click on Services and applications, and then click Configure a Service or Application.

On the Before You Begin page, click Next.

On the Before You Begin page, click Next.

On the Select Service or Application page, select Distributed Transaction Coordinator (DTC) and then Click Next.

On the Select Service or Application page, select Distributed Transaction Coordinator (DTC) and then Click Next.

On the Client Access Point page, enter a Name and an IP address to be used by the DTC, and then click Next.

On the Client Access Point page, enter a Name and an IP address to be used by the DTC, and then click Next.

On the Select Storage page, select the disk you want to use for the MS DTC and then click Next.

On the Select Storage page, select the disk you want to use for the MS DTC and then click Next.

On the Confirmation page, review all the information and then click Next.

On the Confirmation page, review all the information and then click Next.

Wait a few seconds for the progress bar, and then the Summary page will show us the DTC configuration finished successful.

Wait a few seconds for the progress bar, and then the Summary page will show us the DTC configuration finished successful.

That's all for today. I hope you enjoy the reading ! Cheers

 


[Fecha del Artículo (UTC): 08/11/2011]
[Autor: GuilleSQL]



Escribir un Comentario

Para poder escribir un comentario, debe Iniciar Sesión con un usuario.

Si no dispone de un usuario, puede Registrarse y hacerse miembro.

Si dispone de un usuario, pero no recuerda sus credenciales de acceso, puede Restablecer su Contraseña.




User Menu
  Sign in
  Sign up
  Reset password
  Why sign up


Archive

Enero de 2012 (1)
Diciembre de 2011 (1)
Noviembre de 2011 (2)
Octubre de 2011 (1)






This information is provided "AS IS" with no warranties, and confers no rights.

Copyright © 2011 Portal GuilleSQL, all rights reserved.

Page Loads (source: StatCounter):

screen resolution stats
Visits