The issue normally only occurs when MSDTC is using the same cluster virtual name as SQL. The point of failure seems to be API call to “RegConnectRegistryEx” with the SQL network name. When this specific issue occurs, the call returns HR “0x80070035” (ERROR_BAD_NETPATH). This is specifically network path not found. The simplest way to…
Year: 2009
SubInACL Installation
In previous blogs I have discussed the use of the SubInACL tool for changing the Access Control Lists (ACL’s) of services. The tool can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyID=E8BA3E56-D8FE-4A91-93CF-ED6985E3927B&displaylang=en). Please be aware that to use the tool successfully you must install in on the target machine using the MSI file. If you simply copy the SubInACL.exe…
Knowing the limits (MSDTC participant / enlistment limits)
In most cases when flowing a distributed transaction between more than a single machine, a number of Transaction Managers (TM’s) will be involved. In Microsoft’s case the TM implementation is the Microsoft Distributed Transaction Coordinator (MSDTC). The MSDTC representing the machine where the transaction is begun is normally referenced to as the superior MSDTC. The…
MSDTC transaction statistics show a large number of aggregated “Unknown” and “Total” transactions when viewed from a remote machine
Take the scenario whereby MSDTC is configured on Server A and allows remote administration. This means on server B you will be able to add Server A as a remote machine within the component services management snap-in. Once added you will be able to make administrative changes to the MSDTC on Server A from Server…
Windows 2008 SQL Server Cluster (with MSDTC) when using the Windows Firewall with Advanced Security
Take the scenario whereby you have a Windows 2008 Cluster used as a SQL Database Cluster. A common requirement of SQL Server is a Transaction Manager (MSDTC). If your configuration is to have one clustered instance of MSDTC in its own resource group and for any of your SQL server instances to be in their…
You cannot use or configure MSDTC on a Windows 2003 Cluster without a shared disk
On a Windows 2003 cluster you can only ever have one instance of MSDTC running on the cluster at any one time. For this reason and to ensure the running instance of MSDTC is available to all nodes in the cluster, it must be configured as a clustered resource as per http://support.microsoft.com/kb/301600. In order…
You cannot start transactions in an application running without administrative privileges on a Windows 2003 clustered Server
On a Windows 2003 Cluster environment, if you have an application (e.g. COM+, winforms etc) which runs under a non-administrative account and trys to start Distributed Transactions (using MSDTC), you may find it will fail. Below are a few of the errors you could see: -Event ID 4426 MSDTC Client -Event ID 4376 MSDTC Client…