I got the below error log while DTCPing from XXX01 to YYY01 but when I DTCPing from YYY01 to XXX01, RPC is successful.ĭTCPing from DGTPXXX01(DB Server) to DGTPYYY01 (Biztalk Server):Ġ9-07, 12:52:52.429–>Error(0x424) at clutil.cpp 12:52:52.432–>–>OpenClusterĠ9-07, 12:52:52.441–>–>1060(The specified service does not exist as an installed service.) To troubleshoot, still I could not solve this DTC issue and cant configure the Group and Biztalk Runtime sections.ĭGTPXXX01 is my DB server and DGTPYYY01 is Biztalk Server. I followed the links from Steef reply in this post – It looks like there is a problem with MSDTC. Verify that SET options are correct for use with indexed views and or/indexes on computer columns.”

CREATE INDEX Failedīecause the following SET options have incorrect settings: ARITHABORT. “Failed to create Management database “BizTalkMgmtDb” on DB Server. When I try to configure Biztalk on a remote DB server, I got the following error. To execute this tool, just download it, extract all files and execute Tcpview.exe file.

TCPView is a Windows program that will show you detailed listings of all TCP and UDP endpoints on your system, including the local and remote addresses and state of TCP connections. SQL Server 2008 R2 Client Tools – Tools to communicate with the remote instance of SQL Server.The tool performs distributed transactions by using ODBC API against a SQL Server database and can be obtained from Microsoft: How To Use DTCTester Tool This tool helps to test distributed transactions across firewalls or against networks. DTCTester – This tool tests a distributed transaction against a specified Microsoft SQL Server.DTCPing – This tool is designed to assist with troubleshooting Microsoft DTC Firewall Issues and can be obtained from Microsoft: DTCPing.exe.TCPView – This is a Windows program that will show you detailed listings of all TCP and UDP endpoints on your system and can be obtained from Microsoft: TCPView.Before you install and configure BizTalk Server is always a good practice to test or validate the connectivity’s between BizTalk Server and SQL Server machines.

Tcpview windows 2012