Is it mandatory to have msdtc in clustering

  • Hi,

    I would like to know whether msdtc is mandatory for clustering sqlserver. What is the role of msdtc in clustering.

    Thanks

    Chandra Mohan N

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • It is not needed for clustering but if you use DTC for heavy-weight transaction handling then you'll need it.

    Thanks.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

  • This might help:

    http://blogs.msdn.com/sqlblog/archive/2006/10/06/MSDTC-and-SQL-Server-on-a-cluster.aspx

    Not mandatory but highly recommended...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply