none
DTC should be enable to connect SQL server using SQL adapter RRS feed

  • Question

  • DTC should be enable in Sqlserver installed server? , While connecting to Sqlserver to get records using SQL adapter from BizTalk server.

    Is there any other way to connect Sql server ?, without enable DTC in sqlserver installed server .

    Tuesday, August 13, 2013 6:42 AM

Answers

  • Are you using the WCF-SQL Adapter or the old deprecated SQL Adapter?

    If you are using the former, you should be able to set "UseAmbientTransaction" to false under Binding Configuration as stated earlier by Shrikanth. If you are using the latter, I would recommend switching to the WCF-SQL Adapter anyway, and, to my knowledge, the old SQL Adapter don't have the ability to disable transactions.

    Please be aware that disabling transaction is not recommended, especially when receiving SQL data, it could potentially cause lost data and/or data being submitted more than once. 

    Morten la Cour

    • Marked as answer by Pengzhen Song Monday, August 19, 2013 11:27 AM
    Tuesday, August 13, 2013 3:08 PM

All replies

  • I think DTC should be enabled in sql server installed server .

    http://btsguru.blogspot.in/2011/06/biztalk-and-msdtc-dtc-transactions.html

    What problem you are getting ?

    Have you tried making UseAmbient=false ?

    http://msdn.microsoft.com/en-us/library/dd787981.aspx


    Srikanth Peddy. MCTS-BizTalk Server Please mark as answered . http://sharebiztalk.wordpress.com/

    Tuesday, August 13, 2013 7:53 AM
  • Hi srikanth ,

    I know we should enable DTC,but My client is not allow to enable DTC,where sqlserver is installed . He might be thiniking if it enable it will be effect some where in Sqlserver .

    Tuesday, August 13, 2013 8:38 AM
  • Are you using the WCF-SQL Adapter or the old deprecated SQL Adapter?

    If you are using the former, you should be able to set "UseAmbientTransaction" to false under Binding Configuration as stated earlier by Shrikanth. If you are using the latter, I would recommend switching to the WCF-SQL Adapter anyway, and, to my knowledge, the old SQL Adapter don't have the ability to disable transactions.

    Please be aware that disabling transaction is not recommended, especially when receiving SQL data, it could potentially cause lost data and/or data being submitted more than once. 

    Morten la Cour

    • Marked as answer by Pengzhen Song Monday, August 19, 2013 11:27 AM
    Tuesday, August 13, 2013 3:08 PM
  • For the BizTalk databases, DTC is required.  There is no way around that requirement.

    For the SQL Adapters, legacy and WCF, DTC is not required.  On the WCF Adapter, set useAmbientTransaction to False.

    Tuesday, August 13, 2013 4:32 PM