BizTalk Server SQL Adapter: Failed to execute SQL Statement. Please ensure that the supplied syntax is correct. New transaction cannot enlist in the specified transaction coordinator.

simple solution : the machine which you are trying to connect as SQL Server make sure its DTC is enable and configured. to enable and configure DTC Type Dcomcnfg in run then select component services –> Computers –> My Computer , Right Click properties MSDTC Tab Configure and start DTC.

Security Configuration