5

I used Hyper-v to install one windows 2008 server machine, and copy the image to create another one and change the computer name, both of them are in the same domain, and I use a domain user as administrator to configure them.

After installing SQL server 2008, I tried T-SQL below:

SET XACT_ABORT ON
GO

BEGIN DISTRIBUTED TRANSACTION
EXEC CatalogSQLServer.Catalog.dbo.Hello
ROLLBACK

The first time I tried，I got the error information like:

OLE DB provider 'SQLNCLI' for linked server '' returned message 'No transaction is active

I am 100% sure that I have configure DTC,Linked server and allow all inbound and outbound rule of firewall. I configured MSDTC based on these instructions.

after that, I tried use command: 

msdtc -uninstall 
msdtc -install

...and then restart dtc to re-install msdtc on CatalogSQLServer. But this time, when I execute the test script, SSMS will keep executing for a very long time but didn't get any result. Does anybody know how to fix this issue?

Improve this question
3
  • You have followed the directions for both instances?
    – OMG Ponies
    Mar 1, 2012 at 3:59
  • When you do msdtc -uninstall msdtc you will loose all the settings you have made. You need to configure MSDTC after you installed it.
    – Mikael Eriksson
    Mar 1, 2012 at 6:27
  • Can you check DNS, you need to ensure your forward and reverse lookup zones are correct for the two machines.
    – user7637
    Mar 23, 2012 at 17:17

1 Answer 1

Reset to default
1

First check that your computer name is not more than 15 characters as MSDTC relies on NetBIOS , if it is less than that follow the instructions from Microsoft on How to troubleshoot connectivity issues in MS DTC by using the DTCPing tool.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.