Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am receiving errors when I try to run a distributed query against different SQL Server 2008 R2. At first I thought this might be cause the servers have been set up on a VM using a clone but after I discovered that I could run this query on SQL Server 2000 but it fails on a SQL Server 2008 R2 on the same server I am beginning to think that there is something I am just missing.

It does run without any issues on another developers network but it isn't running VMs

Steps I have done so far:

  1. Totally uninstalled MS-DTC, rebooted and installed MS-DTC and another reboot.
  2. Ran Dtcping - no errors
  3. Checked to make sure there are no duplicate SIDs
  4. Asked my non geek wife. She changed the subject to shopping
  5. Rechecked the link servers - everything checks out.
  6. Ran profiler on the transaction - no information given.
  7. Checked the MS-DTC on production boxes to look for anything I might have missed. Also checked out from sp_configure from production boxes to look for anything that I might have missed.
  8. uninstalled/reinstalled MSDTC just in case.
  9. Made sure that the security on DTC isn't stopping me from doing anything.
  10. Firewalls are off on every server I had played with.
  11. Got caught googling MSDTC on my phone while having lunch with my wife.
  12. Updated my servers for with any missing patches.
  13. Talked to my dog about it. At least he listen but didn't have any answers.
  14. Picked up everything and tried it on a different server. No change.
  15. Read the logs from MSDTC to find out that the parent node is the one asking for the abort request
share|improve this question
5  
long story short, what's error? –  SQL Learner Dec 6 '12 at 21:48
    
abort request issued to transaction child node or parent node. The actual error message is deep in the MSDTC logs that need to be translated using tracefmt –  user1207758 Dec 7 '12 at 13:58
    
Another strange development. I attempted to run subinacl to adjust the permission levels - access denied even running as administrator on the server –  user1207758 Dec 10 '12 at 15:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.