SQL Server Performance

MS DTC

Discussion in 'SQL Server Clustering' started by DavidJenkins, Mar 15, 2005.

  1. DavidJenkins New Member

    If you want a single active/passive 2 node SQL2000 SQLcluster (Win2k3-EE)do you need to install DTC?
  2. satya Moderator

    http://www.sql-server-performance.com/sqlserver2000_clustering_install_part1.asp refers... Before SQL Server 2000 can be installed, the MSDTC (which is now a part of SQL Server 2000), must be configured for running in a cluster. Fortunately, this is a simple step.


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. DavidJenkins New Member

    Thanks, but that particular document was one of the very first ones I read regarding SQL clustering. I don't believe it answers my question though. I don't want to know how to set it up (and the method in that document doesn't work as described on 2k3. I want to know if you actually need it for the situation I described in my original post.
  4. satya Moderator

    As mentioned above you need not to install DTC seperately as it is a part of SQL SErver 2000 and you need to configure it.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. ktmohan New Member

    Before starting your installation of SQL Server 2000 and after installing MCS you need to configure MSDTC.

    Mohan Kumar
    MSSQL Database Administrator
  6. DavidJenkins New Member

    My question is do you need to install and configure DTC at all if this is a single sql server instance which is not making calls to remote sql servers at all?
  7. ktmohan New Member

    Yes

    Mohan Kumar
    MSSQL Database Administrator

Share This Page