{"id":1093,"date":"2012-10-10T11:19:36","date_gmt":"2012-10-10T09:19:36","guid":{"rendered":"http:\/\/hen.co.za\/blog\/?p=1093"},"modified":"2012-10-10T11:19:36","modified_gmt":"2012-10-10T09:19:36","slug":"biztalk-and-msdtc","status":"publish","type":"post","link":"https:\/\/hen.co.za\/blog\/2012\/10\/biztalk-and-msdtc\/","title":{"rendered":"BizTalk and MSDTC"},"content":{"rendered":"<p>This is a quick post to summarize my frustrations about the process of setting up and configuring a BizTalk (2010) environment\u00a0 on a multiple server environment.<\/p>\n<p>If you encounter any\/all of the following errors while doing the initial configuration:<\/p>\n<ul>\n<li>Exception of type System.EnterpriseServices.TransactionProxyException was\u00a0thrown<\/li>\n<li>[WARN] AdminLib GetBTSMessage: hrErr=80070002; Msg=The system cannot find the file specified.;<\/li>\n<li>[WARN] AdminLib GetBTSMessage: hrErr=c0c02560; Msg=Failed to read &#8220;KeepDbDebugKey&#8221; from the registry.<\/li>\n<\/ul>\n<p>then start troubleshooting by looking at the following things:<\/p>\n<ol>\n<li>Check that MSDtc is installed, running and configured properly &#8211; especially the security settings. This apply to BOTH the SQL Server and all BizTalk servers! See the following screenshot:\n<div id=\"attachment_1095\" style=\"width: 462px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/hen.co.za\/blog\/wp-content\/uploads\/2012\/10\/BizTalk-MSDtc-Security-settings.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1095\" class=\"size-full wp-image-1095\" title=\"BizTalk MSDtc Security settings\" src=\"https:\/\/hen.co.za\/blog\/wp-content\/uploads\/2012\/10\/BizTalk-MSDtc-Security-settings.png\" alt=\"BizTalk MSDtc Security settings\" width=\"452\" height=\"492\" srcset=\"https:\/\/hen.co.za\/blog\/wp-content\/uploads\/2012\/10\/BizTalk-MSDtc-Security-settings.png 452w, https:\/\/hen.co.za\/blog\/wp-content\/uploads\/2012\/10\/BizTalk-MSDtc-Security-settings-275x300.png 275w\" sizes=\"auto, (max-width: 452px) 100vw, 452px\" \/><\/a><p id=\"caption-attachment-1095\" class=\"wp-caption-text\">BizTalk MSDtc Security settings<\/p><\/div>\n<p>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)<\/li>\n<li>Check that MSDtc has been allowed access through the firewall &#8211; again on ALL machines including the SQL server!\n<p><div id=\"attachment_1096\" style=\"width: 701px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/hen.co.za\/blog\/wp-content\/uploads\/2012\/10\/BizTalk_SQL-MSDtc-Firewall-access.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1096\" class=\"size-full wp-image-1096\" title=\"BizTalk\/SQL MSDtc Firewall access\" src=\"https:\/\/hen.co.za\/blog\/wp-content\/uploads\/2012\/10\/BizTalk_SQL-MSDtc-Firewall-access.png\" alt=\"BizTalk\/SQL MSDtc Firewall access\" width=\"691\" height=\"539\" srcset=\"https:\/\/hen.co.za\/blog\/wp-content\/uploads\/2012\/10\/BizTalk_SQL-MSDtc-Firewall-access.png 691w, https:\/\/hen.co.za\/blog\/wp-content\/uploads\/2012\/10\/BizTalk_SQL-MSDtc-Firewall-access-300x234.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/a><p id=\"caption-attachment-1096\" class=\"wp-caption-text\">BizTalk\/SQL MSDtc Firewall access<\/p><\/div><\/li>\n<li>Check that the SQL Server Browser service is running on the SQL server machine.<\/li>\n<\/ol>\n<p>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 &#8216;stumble&#8217; across this every time you set up a new environment &#8211; Yes you should check these things beforehand I know&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a quick post to summarize my frustrations about the process of setting up and configuring a BizTalk (2010) environment\u00a0 on a multiple server environment. If you encounter any\/all of the following errors while doing the initial configuration: Exception &hellip;<\/p>\n<p class=\"read-more\"><a href=\"https:\/\/hen.co.za\/blog\/2012\/10\/biztalk-and-msdtc\/\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51,16],"tags":[305,222,247,246,29,245],"class_list":["post-1093","post","type-post","status-publish","format-standard","hentry","category-biztalk","category-reference","tag-biztalk","tag-configuration","tag-error","tag-msdtc","tag-problem","tag-server"],"_links":{"self":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/1093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/comments?post=1093"}],"version-history":[{"count":2,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/1093\/revisions"}],"predecessor-version":[{"id":1097,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/1093\/revisions\/1097"}],"wp:attachment":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/media?parent=1093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/categories?post=1093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/tags?post=1093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}