“New transaction cannot enlist in the specified transaction coordinator”

You can encounter same error when you using SQL Adapter.
The reason is simple. You need to check two things to use DTC.

1. Configure DTC both App computer and SQL computer.
2. Make sure each computer can actually ping each other by host name.
(You can simply add host name to \System32\drivers\etc\hosts.)

There are detailed work around I found on newsgroup.