Cross Domain WCF-SQL Adapter communication

Posted on Updated on

For cross domain WCF-SQL adapter communication between servers that communicate, the UseAmbientTransaction property should be set to false to establish the data communication.

Capture1

 

For detailed information of various WCF-SQL adapter properties please refer this.

 

Advertisements

4 thoughts on “Cross Domain WCF-SQL Adapter communication

    Johann said:
    March 30, 2014 at 3:35 am

    Manage to get, not make to get. Doh!

    Johann said:
    March 30, 2014 at 3:33 am

    Thanks for posting this. I did make to get ambient transactions working even though the SQL server was not on the domain. The suggestions in my blog post might or might not help you based on your security constraints but do take a look and let me know how it goes for you – http://adventuresinsidethemessagebox.wordpress.com/2014/03/30/wcf-sql-and-dtc-ambient-transactions-in-a-cross-domain-scenario/

    Cheers
    Johann

      Ritu Raj responded:
      March 30, 2014 at 7:53 am

      Thanks Johann , thanks for posting details around the problem. DTC changes are not allowed to be changed here šŸ˜¦ So only option left was the setting. I do agree that using this is not really suggested as message loss may occur. For UAT and PRD the servers are in same domain tho šŸ™‚

    […] observe different behaviors in the test environment and other environments.Ā  I also found this blog post (no disrespect intended to the writer who took the time to share his learnings) that suggested this […]

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