locked
msdtc transactions fail as it wrongly thinks the machine CIDs are the same! RRS feed

  • Question

  • I have two win2003 servers running sql2000

    I have one set as a linked server of the other to pull datafrom it using dtc.

    When trying to run the query sql returns the error that rpc is not started on the other server, when using dtcping to investigate fully I get:

    ++++++++++++++++++++++++++++++++++++++++++++++
         DTCping 1.8 Report for   
    ++++++++++++++++++++++++++++++++++++++++++++++
    RPC server is ready
    08-12, 13:37:28.359-->RPC server: received following information:
        Network Name: digitalk-sr-408
        Source  Port: 1752
        Partner LOG: 4900.log
        Partner CID: 595A3028-CA7A-4B02-AD83-60812085BA78
    ++++++++++++Validating Remote Computer Name++++++++++++
    08-12, 13:37:31.265-->Start DTC connection test
    Name Resolution:
        digitalk_sr_485-->10.40.110.160-->digitalk_sr_485
    08-12, 13:37:31.265-->Start RPC test (-->digitalk_sr_485)
    WARNING:the CID values for both test machines are the same
        while this problem won't stop DTCping test, MSDTC will fail for this
    08-12, 13:37:31.265-->RPC server: received following information:
        Network Name: digitalk-sr-408
        Source  Port: 1752
        Partner LOG: 5012.log
        Partner CID: F6E76904-20DC-418C-974E-63FA5EF64A74
    RPC test is successful
        Partner's CID:F6E76904-20DC-418C-974E-63FA5EF64A74
    ++++++++++++RPC test completed+++++++++++++++

    Even though it reports the CID values as being the same it clearly shows they aren't!

    I have performed the process for removal of msdtc on both servers and then re-installed msdtc again.

    Msdtc has been configured on both servers in dcomcnfg.exe to allow network dtc and remote clients and authentication has been set to non and the dtc login account is the network service.

    It just seems that the remote server it is being called on is getting confused.

     

    any ideas, full dtcping log below

     

     

    Platform:Windows 2003
    Security settings for DTC under Windows 2003
        NetworkDtcAccess            :true
        NetworkDtcAccessAdmin       :true
        NetworkDtcAccessClients     :true
        NetworkDtcAccessTransactions:true
        NetworkDtcAccessTip         :false
        XaTransactions              :false
        DomainControllerState       :false
        AccountName                 :NT Authority\NetworkService
        TurnOffRpcSecurity          :true

    IP Configure Information
        Host Name . . . . . . . . . : digitalk-sr-408
        DNS Servers . . . . . . . . : 10.40.61.21
        Node Type . . . . . . . . . :
        NetBIOS Scope ID. . . . . . :
        IP Routing Enabled. . . . . : no
        WINS Proxy Enabled. . . . . : yes
        NetBIOS Resolution Uses DNS : no

    Ethernet adapter {1A3CEAB9-73AA-4D2C-8D69-CFE988C95A6A}:

        Description . . . . . . . . : HP Network Team #1
        Physical Address. . . . . . : 00-18-FE-FD-6E-42
        DHCP Enabled. . . . . . . . : no
        IP Address. . . . . . . . . : 10.40.110.102
        Subnet Mask . . . . . . . . : 255.255.255.0
        Default Gateway . . . . . . : 10.40.110.1
        DHCP Server . . . . . . . . : 255.255.255.255
        Primary WINS Server . . . . : 0.0.0.0
        Secondary WINS Server . . . : 0.0.0.0
        Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
        Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970

    Ethernet adapter {0FF0C544-2E5A-4EFF-95B2-E4FC299F1986}:

        Description . . . . . . . . : HP NC7771 Gigabit Server Adapter
        Physical Address. . . . . . : 00-17-08-2B-EA-95
        DHCP Enabled. . . . . . . . : no
        IP Address. . . . . . . . . : 100.100.100.2
        Subnet Mask . . . . . . . . : 255.0.0.0
        Default Gateway . . . . . . :
        DHCP Server . . . . . . . . : 255.255.255.255
        Primary WINS Server . . . . : 0.0.0.0
        Secondary WINS Server . . . : 0.0.0.0
        Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
        Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970

    ++++++++++++lmhosts.sam++++++++++++

    ++++++++++++hosts      ++++++++++++
    127.0.0.1       localhost
    10.40.110.101    digitalk-sr-407
    10.40.110.102    digitalk-sr-408
    10.40.110.160    digitalk_sr_485

    ++++++++++++++++++++++++++++++++++++++++++++++
         DTCping 1.8 Report for  
    ++++++++++++++++++++++++++++++++++++++++++++++
    RPC server is ready
    08-12, 13:37:28.359-->RPC server: received following information:
        Network Name: digitalk-sr-408
        Source  Port: 1752
        Partner LOG: 4900.log
        Partner CID: 595A3028-CA7A-4B02-AD83-60812085BA78
    ++++++++++++Validating Remote Computer Name++++++++++++
    08-12, 13:37:31.265-->Start DTC connection test
    Name Resolution:
        digitalk_sr_485-->10.40.110.160-->digitalk_sr_485
    08-12, 13:37:31.265-->Start RPC test (-->digitalk_sr_485)
    WARNING:the CID values for both test machines are the same
        while this problem won't stop DTCping test, MSDTC will fail for this
    08-12, 13:37:31.265-->RPC server: received following information:
        Network Name: digitalk-sr-408
        Source  Port: 1752
        Partner LOG: 5012.log
        Partner CID: F6E76904-20DC-418C-974E-63FA5EF64A74
    RPC test is successful
        Partner's CID:F6E76904-20DC-418C-974E-63FA5EF64A74
    ++++++++++++RPC test completed+++++++++++++++
    ++++++++++++Start DTC Binding Test +++++++++++++
    Trying Bind to
    08-12, 13:37:31.281--> Initiating DTC Binding Test....
        Test Guid:F6E76904-20DC-418C-974E-63FA5EF64A74
    ++++++++++++Start Reverse Bind Test+++++++++++++
    Received Bind call from
        Network Name: digitalk-sr-408
        Source  Port: 1752
        Hosting Machine:
    08-12, 13:37:31.281-->Trying to Reverse Bind to ...
        Test Guid:F6E76904-20DC-418C-974E-63FA5EF64A74
    Name Resolution:
        -->10.40.110.102-->digitalk-sr-408
    Received reverse bind call from
        Network Name: digitalk-sr-408
        Source  Port: 1752
        Hosting Machine:
    Reverse Binding success: -->
    ++++++++++++Reverse Bind Test ENDED++++++++++
    Binding success: -->
    ++++++++++++DTC Binding Test END+++++++++++++

    Thursday, August 12, 2010 1:55 PM

All replies

  • Hello there,

     

    Some links are given below

     

    The remote server or share does not support transacted file operations
    http://offroadcoder.com/CategoryView,category,MSDTC.aspx
    http://offroadcoder.com/2009/01/29/TheFlowedTransactionCouldNotBeUnmarshaled.aspx

    Troubleshooting Problems with MSDTC
    http://msdn.microsoft.com/en-us/library/aa561924%28BTS.70%29.aspx

    Hope this helps.

     

    Regards,

    Phijo Mathew Philip.

     

     


    PHIJO MP
    Thursday, September 23, 2010 12:23 PM
  • Sadly, these are the steps that I have already tried and only work where the cid values are the same, in this case they aren't, but windows thinks they are!
    Wednesday, September 29, 2010 10:34 AM