BizTalk SQL Adaptor Error (Transaction Can’t Enlist)

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



 ControlPanel->Administrative Tools -> Component Services


– ComponentServices


         +My Computer

                Right Click My Computer and select “Properties”




And configure DTC with the below settings


Tagged with:
Posted in 1, LinkedIn

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: