SQL Server Home
Cluster Setup - Denali CTP1 incorrect warning - Rule "Distributed Transaction Coordinator (MSDTC) clustered" generated a warning
as Won't Fix
11/4/2010 6:58:02 PM
User(s) can reproduce this bug
In many cases your intent is to cluster DTC later after the SQL Install so that it is failover with the SQL Cluster.
Instead of raising a warning, ask if MSDTC is going to be installed, and how.
This warning is not correct. it is only correct if the intent was to have DTC clustered prior to SQL. which in most cases is not the best solution.
so I'm adding the MSDTC to an existing CLuster resource, in this case SQL Server, and that way I do not need a dedicated LUN
SQL Server Denali CTP 1
Windows Server 2008 R2
Operating System Language
Steps to Reproduce
Cluster install of SQL Denali CTP1 and CTP0
when it gets to the validation steps it incorrectly warns of an issue with MSDTC. In my mind it should ask as part of the setup wizard what type of MSDTC install is planned. if the planned is to cluster MSDTC after SQL is installed, then the wizard also should provide taht step, instead of having me maually create "Client Access Point"
Rule Check Result
Rule "Distributed Transaction Coordinator (MSDTC) clustered" generated a warning.
The MSDTC service is not clustered. Beginning with Windows Server 2008, SQL Server Setup does not require MSDTC to be clustered. For more information about the benefits of clustering MSDTC, see http://technet.microsoft.com/en-us/library/cc730992(WS.10).aspx. On earlier operating systems, the MSDTC service must be clustered for SQL Server Setup and other SQL Server features to work correctly. You can cluster the MSDTC service using the Windows Cluster Administrator MMC snap-in.
1) add a new step to the wizard to ask what type of MSDTC install you are planing
2) at the end, if I selected to cluster MSDTC on the SQL Resource, then add the "Client Access Point" and the DTC resrouce.
to post a comment.
Please enter a comment.
on 5/6/2011 at 1:04 PM
Triage confirmed that we currently do not have any plans to incorporate DTC scenarios into our workflow. We are closing this as won't fix. Thank you for your suggestion.
Microsoft SQL Server
on 12/1/2010 at 5:19 PM
Thank you very much for your feedback. We will evalute this and get back to you as new information becomes available.
Microsoft SQL Server
to post a workaround.
Please enter a workaround.
© 2013 Microsoft