Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: MSDTC and SQL2000 clustered

    Hi,

    I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).

    I suppose MSDTC was not activated during SQL2000 setup.

    Is it absolutely necessary?
    Can I have problems?

    In what case is it necessary?

    Many thanks?

  2. #2
    Join Date
    Jun 2003
    Posts
    1

    Re: MSDTC and SQL2000 clustered

    Originally posted by nisant
    Hi,

    I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).

    I suppose MSDTC was not activated during SQL2000 setup.

    Is it absolutely necessary?
    Can I have problems?

    In what case is it necessary?

    Many thanks?
    I had a problem in an active\active failover installation. MSDTC was not configured and was causing problems with the fail over function. Once I configured it as a shared resource, everything seemed fine. Hope this helps...

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, make sure MSDTC has been started and working whenever any distributed transactions are in process.

    For information refer to DB journal article.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •