You cannot start transactions from a COM+ component on a clustered SQL Server server

When you try to start a transaction from a COM+ component on a clustered Microsoft SQL Server server, the transaction does not start. When this occurs, the following error message may be logged in the event log:

Event Type: Error
Event Source: MSDTC Client
Event Category: MSDTC Proxy
Event ID: 4376
Description: The application could not connect to MSDTC because of insufficient permissions. Please make sure that the identity under which the application is running has permission to access the cluster. Please refer to MSCS documentation on how to grant permissions. Error Specifics: d:\srvrtm\com\complus\dtc\dtc\msdtcprx\src\dtcinit.cpp:652, Pid: 4544

COM+ application identities must be in the Administrator group on Microsoft Cluster Server (MSCS) clusters. For COM+ applications on MSCS clusters, the user account that is associated with the application identity must be a System Administrator account or must have Full Control cluster access permissions as set in the Cluster Administrator (Cluadmin.exe). If you do not use a System Administrator account to run the package, the COM+ application cannot connect to the Microsoft Distributed Transaction Coordinator (MSDTC).

This behavior is by design.

For more information about how to add the required credentials, click the following article number to view the article in the Microsoft Knowledge Base: The following syntax lets you modify cluster permissions by using the properties parameter ( /prop ) of the Cluster.exe command. NoteClusterName is the name of the cluster that you want to add users to.