Windows2003 sever 中的组件运行会报"新事务不能登记到指定的事务处理器中"
DTC server
Error message: OLE DB provider SQLOLEDB was unable to begin
a distributed transaction
View products that this article applies to.
Article ID : 816701
Last Review : March 4, 2005
Revision : 4.0
SYMPTOMS
When you try to use Microsoft SQL Server 2000 to start a distributed transaction between linked servers that are running Windows Server 2003, you may receive the following error message:
OLE DB provider SQLOLEDB was unable to begin
a distributed transaction
The following message may appear on the OLE DB provider computer:
New transaction cannot enlist in the specified transaction coordinator.
CAUSE
This behavior occurs if the Distributed Transaction Coordinator (DTS) service is disabled or if network DTC access is disabled. By default, network DTC access is disabled in Windows Server 2003.
WORKAROUND
To work around this behavior, install network DTC access on both servers: 1. Click Start, and then
click Control Panel.
2. Click Add or Remove Programs, and then
click Add/Remove Windows Components.
3. In the Components box, click Application Server, and then
click Details.
4. Click to select the Enable network DTC access check box, and then
click OK.
5. Click Next, and then
follow the instructions that appear on the screen to complete the installation process.
6. Stop and then
restart the Distributed Transaction Coordinator service.
7. Stop and then
restart any resource manager services that participates in the distributed transaction (such as Microsoft SQL Server or Microsoft Message Queue Server).
