July 22, 2015 at 7:46 am
I am going to configure HA - Active - Active Failover cluster using 2 Nodes.
I have already installed Windows Failover cluster.
Before SQL server installation, We need to configure MSTDC Right? I have 2 MSDTC SAN drives.
Could you please suggest me how to configure MSDTC before SQL Server 2012 Failover cluster installation.
<<I need to create HA- Active active 2 node cluster. I.e. I need to have 2 instance in 2 node. >>
July 22, 2015 at 7:52 am
why don't you try google and search for "create msdtc cluster resource 2012"??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2015 at 4:14 am
You can install MSDTC before or after SQL Server installation. If your Windows cluster is going to host a single SQL Server instance you can set up MSDTC resource to use the same SQL Server cluster group. If you want to keep MSDTC isolated or you are going to use multiple SQL Server instances and want to use a single MSDTC, you can created its own cluster group.
If your SQL Server client application do not use distributed transactions do not install it.
MSDTC Recommendations on SQL Failover Cluster
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply