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:

Error: 

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.

 

Solution:

 ControlPanel->Administrative Tools -> Component Services

Expand

– ComponentServices

    -Computer

         +My Computer

                Right Click My Computer and select “Properties”

 

 

 

And configure DTC with the below settings

 

Advertisements
Tagged with:
Posted in 1, LinkedIn

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: