I am making a 2 node SQL Server 2012 Fail Over Cluster, do I need to install MSDTC also?
If yes then can both be installed on single shared disk?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.
just to link sQL servers why would you need MSDTC ? unless the sql servers are using the a distributed transaction in the tsql