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:


EXEC CatalogSQLServer.Catalog.dbo.Hello

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?

  • You have followed the directions for both instances? – OMG Ponies Mar 1 '12 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 '12 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 '12 at 17:17

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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