unable to begin a distributed transaction

Posted on 2008-11-11
Last Modified: 2012-05-05
sql v2000 sp4, servers are linked, haven't had this problem before now --
simply trying to select from one server to the other (which is linked) --

select top 1 * from otherserver.database.dbo.view

fails with this:
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

very urgent, please advise
Question by:dbaSQL
    LVL 31

    Accepted Solution

    have you read

    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.
    LVL 17

    Author Comment

    Yes, I've seen that.  I'm looking at the MSDTC now, only one of the resources even has all the options you mention.  I see two of them are of version
    sql is at v2000 sp4, but possibly msdtc needs upgrade?
    LVL 31

    Expert Comment

    by:James Murrell
    possibly msdtc needs upgrade?  possible
    LVL 17

    Author Comment

    i'm not sure why i don't have this problem on any other machine.  what do you suggest re this upgrade?
    LVL 17

    Author Comment

    are you able to advise on the upgrade?  i've never JUST upgraded msdtc
    LVL 17

    Author Comment

    if msdtc needs to be upgraded, i'll figure it out.  thanks for looking

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now