Access to a Stored Procedure on a remote SQL Server via Microsoft Biztalk SQL Adapter

If it is neccesary to access a stored procedure on a remote SQL Server by SQL Adapter, you have to activate the DTC Network access in the security options of component services.

Error message: “Transaction could not enlist in the Transaction coordinator”.

Security setting:

Further informations: http://msdn.microsoft.com/en-us/library/aa561924.aspx.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.