unable to begin a distributed transaction

Posted on 2008-11-11
Medium Priority
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
  • 4
  • 2
LVL 31

Accepted Solution

James Murrell earned 1200 total points
ID: 22930147
have you read http://support.microsoft.com/kb/329332

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

ID: 22930256
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
ID: 22932215
possibly msdtc needs upgrade?  possible
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

LVL 17

Author Comment

ID: 22932237
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

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

Author Comment

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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

850 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