Unable to view or change the properties (Tracing, Logging or Security settings) in Component Services for a clustered instance of MSDTC which resides in a SQL Server cluster resource group

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…

0

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…

0

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…

0

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…

0

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…

1

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…

1