unable to begin a distributed transaction

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
LVL 18
dbaSQLAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James MurrellProduct SpecialistCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dbaSQLAuthor Commented:
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 03.00.00.3511.
sql is at v2000 sp4, but possibly msdtc needs upgrade?
0
James MurrellProduct SpecialistCommented:
possibly msdtc needs upgrade?  possible
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

dbaSQLAuthor Commented:
i'm not sure why i don't have this problem on any other machine.  what do you suggest re this upgrade?
0
dbaSQLAuthor Commented:
are you able to advise on the upgrade?  i've never JUST upgraded msdtc
0
dbaSQLAuthor Commented:
if msdtc needs to be upgraded, i'll figure it out.  thanks for looking
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.