大网数据广告活动
数据库与应用安全

Error message of OLE DB provider

· 52CE 我爱测

This article provides workaround for the error message of OLE DB provider SQLOLEDB was unable to begin a distributed transaction.

This article helps you work around the problem that error message of OLE DB provider SQLOLEDB was unable to begin a distributed transaction.

Original product version:   SQL Server
Original KB number:   816701

Symptoms

When you try to use Microsoft SQL Server to start a distributed transaction between linked servers that are running Windows Server, 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.

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

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 09/25/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。