The Temple of Fu

code, systems and games

The operation could not be performed because the OLE DB provider ‘SQLOLEDB’ was unable to begin a distributed transaction

with 2 comments

A developer at work today encountered the error below when trying to insert stored procedure results into a temp table where the stored procedure contains a reference to a linked server. Well fortunately he fixed it and shared his information so I am sharing it with you.

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. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

He enabled the MSDTC service but still received the error. In order to completely fix this error he had to perform the following to enable network access, by default the network access settings of MSDTC are disabled on new installations of SQL Server 2000 on computers that are running Windows Server 2003.

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.
    In the Components box, click Application Server, and then click Details.
  3. Click to select the Enable network DTC access check box, and then click OK.
  4. Click Next, and then follow the instructions that appear on the screen to complete the installation process.
  5. Stop and then restart the Distributed Transaction Coordinator service.
  6. Stop and then restart any resource manager services that participates in the distributed transaction (such as Microsoft SQL Server or Microsoft Message Queue Server).

References:
Microsoft Support

Advertisements

Written by lordfu

March 25, 2010 at 11:53 am

Posted in Database, MSSQL

2 Responses

Subscribe to comments with RSS.

  1. You are welcome.

    I hope others will find it usefull too.

    Don

    March 25, 2010 at 12:03 pm

    • I am having same problem but my OS platform is Windows XP SP2. There is no Application server installed. How do I get a rid from this situation.

      Debasis

      April 27, 2012 at 2:48 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: