This is a quick post to summarize my frustrations about the process of setting up and configuring a BizTalk (2010) environment on a multiple server environment.
If you encounter any/all of the following errors while doing the initial configuration:
- Exception of type System.EnterpriseServices.TransactionProxyException was thrown
- [WARN] AdminLib GetBTSMessage: hrErr=80070002; Msg=The system cannot find the file specified.;
- [WARN] AdminLib GetBTSMessage: hrErr=c0c02560; Msg=Failed to read “KeepDbDebugKey” from the registry.
then start troubleshooting by looking at the following things:
- Check that MSDtc is installed, running and configured properly – especially the security settings. This apply to BOTH the SQL Server and all BizTalk servers! See the following screenshot:
BizTalk MSDtc Security settings
The Type of communication can be changed to Mutual or Incoming Caller but it HAS to be the same on all the machines (SQL and BizTalk servers)
- Check that MSDtc has been allowed access through the firewall – again on ALL machines including the SQL server!
BizTalk/SQL MSDtc Firewall access
- Check that the SQL Server Browser service is running on the SQL server machine.
I really hope that Microsoft will one day fix this issue where the Configuration Wizard does not check these things BEFORE you start trying to apply settings. It is really frustrating that you have to ‘stumble’ across this every time you set up a new environment – Yes you should check these things beforehand I know…