Microsoft KB Archive Search

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.

  1. Home
  2. You receive error 7391 when you run a distributed transaction against a linked server in SQL Server 2000 on a computer that is running Windows Server 2003

You receive error 7391 when you run a distributed transaction against a linked server in SQL Server 2000 on a computer that is running Windows Server 2003

Symptoms

When you run a distributed transaction against a linked server in Microsoft SQL Server 2000 on a computer that is running Microsoft Windows Server 2003, you may receive the following error message:
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.

↑ Back to the top

Cause

The problem occurs because Microsoft Distributed Transaction Coordinator (MS DTC) is not configured for network access. By default, the network access settings of MS DTC are disabled on new installations of SQL Server 2000 on computers that are running Windows Server 2003.

↑ Back to the top

Resolution

To resolve this problem, follow these steps:
  1. Click Start, point to All Programs, point to Administrative Tools, and then click Component Services.
  2. In the Component Services Wizard, expand Component Services, and then double-click Computers.
  3. Right-click My Computer, and then click
    Properties.
  4. Click the MS DTC tab, and then click
    Security Configuration.
  5. In the Security Configuration dialog box, click to select the Network DTC Access check box.
  6. Under Network DTC Access, click
    Network Transactions.

    Note If you installed Service Pack 1 for Windows Server 2003, you can click Allow Inbound and Allow Outbound.
  7. Make sure that DTC Logon Account is set to
    NT Authority\NetworkService.
  8. Click OK.
  9. In the message box, click Yes to continue.
  10. In the DTC Console Message dialog box, click OK.
  11. In the System Properties dialog box, click
    OK.
  12. Reboot the computer for these changes to take effect.

    Note In some cases, you must start the DTC service before you start the SQL Server service so that the linked server distributed queries work well.

↑ Back to the top

References

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

306843 How to troubleshoot MS DTC firewall issues

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

871158 You cannot install Microsoft Office Project Server 2003 on Microsoft Windows Server 2003

↑ Back to the top

Keywords: kbbillprodsweep, kberrmsg, kbbug, kbprb, kb, misc_migrate_32718

↑ Back to the top

Article Info
Article ID : 329332
Revision : 2
Created on : 4/13/2018
Published on : 4/13/2018
Exists online : False
Views : 97