SQL Server Performance

Problems with DTC on Clustered SQL database.

Discussion in 'SQL Server Clustering' started by hmckillop, Sep 1, 2003.

  1. hmckillop New Member

    Has anyone successfully managed to create DTC transactions on a clustered SQL database?
    We are experiencing problems trying to get the DTCs to work. (We also know they work successfully when on a non-clustered SQL DB).
    Thanks in advance.
  2. Twan New Member

    Hi Hugh,

    I've not tried to use DTC on a cluster, but may be able to help anyway...?

    Have you set up DTC to be cluster-aware?
    >>>>
    Start comclust.exe from the command prompt.
    When it is done, go to the Cluster Administrator and verify that MSDTC has been added to the Cluster Group as one of the shared resources.
    Repeat the same procedure for each server node
    >>>>

    Are you getting any specific errors? What OS, SQL, etc. are you running?

    Cheers
    Twan

    PS also this link may help troubleshoot DTC http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q306843
  3. satya Moderator

    Hugh

    Kindly post thread in relevant forum, follow Twan's suggestion for workaround.
    (email'd WM to move the post)

    I'm sure you can modify the thread and move it to Cluster Forum.

    Thanks.
    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  4. Argyle New Member

    1.
    MSDTC has to be running on both the SQL Server and the client machine/server (web/app server, workstation etc.) to be able to work.

    2.
    If the MSDTC service is running on both machines but still doesn't work then it's most likely due to a name resolution issue or a firewall. MSDTC needs to be able to do name lookups (in both directions) on the servers involved to be able to function.

    To check this try and ping the SQL server by name from the web/app server and vice versa ping the web/app server by name from the SQL server. Be sure to ping the virtual SQL Server name.

    Use the DTCping.exe utility that Twan refered to:
    http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q306843

    You will notice (when using DTCping) that even if the client connects to the MSDTC service trough the virtual SQL Server name it will sometimes still resolve the physical node name of the node that currently owns the MSDTC service in the cluster. So make sure that name reolution works for the physical node names as well and not only the virtual names.

    3.
    If DNS or WINS are miss-configured or traffic is blocked in routers or something then add name and IP address entries in "lmhosts" and "hosts" files on the involved SQL server and web/app server or fix the DNS or WINS.

    4.
    If there is a firewall between the servers look at this article on what ports to open:

    INFO: Configuring Microsoft Distributed Transaction Coordinator (DTC) to Work Through a Firewall (Q250367)
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;q250367

    /Argyle
  5. satya Moderator

    Hugh kindly act as advised to move the thread.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  6. hmckillop New Member

    How do I move the thread?
  7. satya Moderator

    Edit your first post above by clicking Edit Reply button (with a pen/letter icon) and change the Forum name from list box.

    Thanks

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  8. thamest New Member

    I just did an sp_helpserver on both the old server and new server.

    The old server has both the SQL server AND the Web server listed. The SQL server has an ID of 0 and the web server has an id of 2.

    The new server only lists the SQL Server. It DOES NOT list the Web server when I execute the sp_helpserver.

    How can I add the web server so it will show up when I execute sp_helpserver on the new server? Could this be my problem???
  9. Luis Martin Moderator

    Thamest:

    Kindly post thread in relevant forum.

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  10. satya Moderator

    SP_HELPSERVER reports information about a particular remote or replication server, or about all servers of both types. And it relates to only SQL Server not for non-SQL servers.

    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.

Share This Page