I am installing SQL Server 2008 r2 SP1 on a 64-BIT Windows Server 2008 r2 SP1 Enterprise server in an Active/Passive failover cluster environment.
I am trying to cover all my bases and following the documentation provided by msdn...
I am going through the 'Before Installing Failover Clustering' ( http://msdn.microsoft.com/en-us/library/ms189910.aspx
My question pertains to the following part of this article:
Install Microsoft Distributed Transaction Coordinator
Before installing SQL Server on a failover cluster, determine whether the Microsoft Distributed Transaction Coordinator (MSDTC) cluster resource must be created. If you are installing only the Database Engine, the MSDTC cluster resource is not required. If you are installing the Database Engine and SSIS, Workstation Components, or if you will use distributed transactions, you must install MSDTC. Note that MSDTC is not required for Analysis Services-only instances.
Configure Microsoft Distributed Transaction Coordinator
After you install the operating system and configure your cluster, you must configure MSDTC to work in a cluster by using the Cluster Administrator. Failure to cluster MSDTC will not block SQL Server Setup, but SQL Server application functionality may be affected if MSDTC is not properly configured.
I am installing the Database Engine and SSIS which puts me into the must install MSDTC category.
My question pertains to the statement 'you must configure MSDTC to work in a cluster by using the Cluster Administrator'.
Can someone provide an article for a best practice for how to do this?
Do I need to also (is it required/can I get away without)?...
Enable Network Access Securely For MS DTC (http://technet.microsoft.com/en-us/library/cc753620(WS.10).aspx
Enable Network DTC Access ( http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx
For now I will not be doing the two items above, but I feel that I will need to configure MSDTC to work in a cluster.
I really do not want to over configure this environment for features which I do not need.
Any advice would be useful.