Microsoft KB Archive/316881

Knowledge Base

PRB: Cannot Initialize Transactions from an MTS Component on a Clustered SQL Server

Article ID: 316881

Article Last Modified on 5/22/2007

---

APPLIES TO

• Microsoft Transaction Services 2.0

---

This article was previously published under Q316881

SYMPTOMS

On a clustered SQL Server with Microsoft Transaction Server (MTS) components, you may receive the following error message in the event log:

The run-time environment was unable to initialize for transactions required to support transactional components. Make sure that MS DTC is running.(DtcGetTransactionManagerEx(): hr = 0x80070005) 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: .\dtcinit.cpp:366, CmdLine: C:\WINNT\System32\dllhost.exe /Processid:{8413D71C-0027-4340-A1C2-6DC080A27942}, Pid: 588

CAUSE

MTS package identities must be in Administrator Group on Microsoft Cluster Server (MSCS) clusters. For MTS packages on MSCS clusters, the user account associated with the package identity must be a system administrator or must have Full Control cluster access permissions as set in the Cluster Administrator (Cluadmin.exe). If you do not run the package with the identity of a system administrator, MTS cannot connect to the Microsoft Distributed Transaction Coordinator (MSDTC).

STATUS

This behavior is by design.

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.

Additional query words: server cluster

Keywords: kbdatabase kbdtc kbprb KB316881

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.