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 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?

share|improve this question
    
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
add comment

1 Answer

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.

share|improve this answer
add comment

Your Answer

 
discard

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

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