I am making a 2 node SQL Server 2012 Failover Cluster; do I need to install the MSDTC component?
If yes, can both be installed on single shared disk?
Sql-server – Is MSDTC required for SQL Server 2012 Fail Over Cluster
clusteringfailovermsdtcsql serversql-server-2012
Related Question
- Sql-server – Single disk for Data, System, User, Temp and Backup when installing Fail Over Cluster
- SQL Server – Upgrading a Single SQL Server 2008 Failover Cluster Instance to SQL Server 2012
- SQL Server 2012 – Cluster Service Pack 3 Fail to Failover Node
- SQL Server 2012 – Upgrade Windows 2008 R2 Cluster to 2012 R2
- SQL Server – Understanding Active/Active Cluster
- How to Install New SQL Server Cluster Instance Without Downtime
Best Answer
MSDTC is not required for a SQL Server 2012 fail over cluster. However, if you plan to use Linked Servers, then you will need to create a clustered MSDTC resource. The good news is that can be setup after the cluster is already built and after SQL Server has been installed.