sql adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › sql adapter

Viewing 1 reply thread
  • Author
    Posts
    • January 10, 2006 at 5:04 AM #12630
      community-content

        hi

        in my program i am using multiple sql adapters to retrieve data from one db and insert into other db

        and then combining orchestrations for each sql adapter

        my one db is on different sql server

        after deployment

        no error comes

        but warning

        ‘New transaction cannot enlist in the specified transaction coordinator’

        comes and nothing happens

        HAT i\\also do not show anything

      • January 11, 2006 at 6:53 PM #12631
        community-content

          1) Go to the machine where SQL Server is running.
          2) Go to Admin Tools
          3) Component (COM) Services
          4) Expand Component Services down to \”My Computer\”
          5) Right click properties.
          6) Click tab MSDTC
          7) Click button \”Security Configuration\” at lower left
          8) Check \”Network DTC Access\” and \”Allow Remote Clients\”
          9) I’m not positive, but might also have to check:
          Allow Inbound, Allow Outbound, No Authenticiation Required
          (might have to Google for exact settings)
          10) Click OK, OK
          11) Might have to stop/start MSDTC (right click on \”My Computer\”)

          Neal Walters
          http://Biztalk-Training.com – Video Tutorials

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.