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 created an application that is making use of MSDTC (to open a transaction on multiple databases within the same MS SQL server), our local environment was setup successfully and both DTCPing, DTCTester and the application work. However when it came to deployment I encountered issues when setting up the client computer to make use of the server's coordinator.

On Client site I have tried the following:

  • DTC Ping passed successfully
  • Setting Coordinator to the server one results into the following error "The specified remote host machine does not exist"
  • I am able to ping the server using host name

When I tried running DTC tester, it output the following:

Executed: dtctester.exe
DSN:  accdim
User Name: sa
Password: <hidden>
tablename= #dtc16397
Creating Temp Table for Testing: #dtc16397
Warning: No Columns in Result Set From Executing: 'create table #dtc16397 (ival int)'
Initializing DTC
DtcGetTransactionManager failed: 8004d01b
DtcGetTransactionManager Call Error: Indicates unable to connect to the transaction manager, or the transaction manager is unavailable.
share|improve this question

1 Answer 1

up vote 0 down vote accepted

This ended out being a domain policy issue, the computer was moved to an other group and MSDTC was registered and working successfully.

share|improve this answer

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.