MSDTC

Question

I have installed sql server 2012 on windows 2012 cluster(Active/passive) also I have installed MSDTC.

Our application guy complaining that he can't connect to the cluster, i have checked my windows  log saying msdtc could'nt connect, so i have deleted MSDTC from failover cluster manager .

Is there any possibility to bring back MSDTC back to my roles, i haven't deleted the storage and network name of the msdtc

Please help me

Thanks

Answer 1

You can add back the MSDTC to the cluster as explained here. However, starting from Windows 2008 you no longer need to cluster MSDTC even when you are running a cluster. See this blog for details.

---

Satish Kartan www.sqlfood.com

Answer 2

Please see this link:

Troubleshooting Problems with MSDTC

---

T-SQL Articles
T-SQL e-book by TechNet Wiki Community
T-SQL blog