Dot Net Tips and Tricks

Having spent some time working with WF ’s SqlTrackingService and SqlWorkflowPersistenceService to work with Sql Server 2005 on a seperate machine, I’ve put together a few links to help others.

NOTE: Certain transactions in Windows Workflow Foundation are promoted to DTC transaction when the stores are located on different machines.

• I found that the most helpful tool was DTCPing.
• A very easy program that can be used to test firewall issues and the simple connection between 2 computers over DTC.
• The second and more comprehensive was DTCTester.
• This will simulate a full sql transaction between computers.