sql server connect: DTC Error -- sql server connect

DTC Error

David Liu
4/22/2004 12:05:28 PM

sql server connect:

I have a project with two SQL servers on two seperate
subnet, following distribute query will run on B server.

update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set
uploadstatus='InProgress'

If I include this statement in Transaction Like this way:

Begin Tran
update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set
uploadstatus='InProgress'
commit Tran

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

Link server is setup okay for sure, any suggestions from
microsoft?

For DTC , two sql server have to be the same subnet or
same domain?

Thanks

David Liu
MCSE/MCDBA
Moneris.com

Re: DTC Error

David Liu
4/23/2004 6:21:46 AM

Both of them are Windows 2000 Advanced Server.

Does this case need to be same subnet and same domain?

DTC use RPC for communication for sure.

Really wired

Thanks for your information

[quoted text, click to view]

Re: DTC Error

Andy Ball
4/23/2004 6:21:41 PM

Is one of the servers Windows Server 2003 by any chance - see below

http://support.microsoft.com/default.aspx?scid=kb;en-us;816701

--
Andy Ball
Greenfell Computing Ltd
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.