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.