August 7, 2013 at 5:07 am
One of our client want dba to install sql cluster 2008 r2 on single cluster node.
(maybe in the future a second node will be add to the cluster).
Can any one clarify the below things.
IS it possible to configure msdtc with out secodary node.?
Is it possible to install sql cluster on 2008R2 on sinlge node with out configuring MSDTC? or
can we create MSDTC after adding the 2nd node to the existing single node cluster?
Advance thanks,
August 12, 2013 at 3:00 am
You can create a SQL cluster without MSDTC, but normally MSDTC would be involved.
There is nothing stopping you creating a single-node MSDTC cluster to live with your single-node SQL cluster.
If you use FineBuild to run the install process, that is exactly what it does. All the configuration needed for each node is done when FineBuild is run on that node, so you do not get a two-node SQL or MSDTC cluster until FineBuild is run on node 2.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply