Yestarday i was deploying an BizTalk application that i had been using for a while, with one minor change, the backend database. I switched from a local development database, using Windows Authentication, to a production data base with SQL Authentication. The only real thing that changed was the authentication, but regardless i was receiving the error below:
The adapter “SQL” raised an error message. Details “New transaction cannot enlist in the specified transaction coordinator. “.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
ControlPanel->Administrative Tools -> Component Services
Right Click My Computer and select “Properties”
And configure DTC with the below settings