Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

Symptoms

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

↑ Back to the top


Cause

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).

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


More information

For more information about how to add the required credentials, click the following article number to view the article in the Microsoft Knowledge Base:
828289 How to use the Cluster.exe command to modify the Security Descriptor object on Windows 2000 and Windows Server 2003 clusters
The following syntax lets you modify cluster permissions by using the properties parameter ( /prop ) of the Cluster.exe command.
Cluster ClusterName /prop "security descriptor"= DOMAIN\USER ,grant,f:security
NoteClusterName is the name of the cluster that you want to add users to.

↑ Back to the top


Keywords: kbtshoot, kbdatabase, kbdtc, kbprb, KB316881

↑ Back to the top

Article Info
Article ID : 316881
Revision : 3
Created on : 3/20/2009
Published on : 3/20/2009
Exists online : False
Views : 75