Post reply

please help!! - Transaction code failure on Cluster server

  • February 26, 2007 at 9:56 am

    #61880

    I have a procedure creating the linked server from the sql db ( lets say A) in window 2003 ( cluster server ) to the sql db in window 2003 ( non cluster) ( lets say B)

    and the procedure also get data from a table in A and insert to table in B

    I granted the network MSDTC access for all three servers and all the setting is correct.

    the procedure has Transaction code in it to roll back the transaction on failure.

    That is where it doesn't work. I get the error message following.

    The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

     

    If I removed the transaction code, it works fine from A to B

     

    when I try from window 2003 non cluster server ( lets say C ) to  B server, it works fine with transaction code in it...

     

    Below url are the references I used to set everything.

    http://support.microsoft.com/kb/329332

    http://support.microsoft.com/default.aspx?scid=kb;en-us;816701

    http://support.microsoft.com/kb/301600/

    http://support.microsoft.com/default.aspx?scid=kb;en-us;889706

    any idea!?!??!

     

    Thanks

     

     

     

     

  • February 26, 2007 at 3:46 pm

    #691912

    It might be security / service account permissions. I can't think of anything that a cluster changes, unless it's at a different service pack level , o/s.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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