Hello,

may be a dumb question, but how do i determine if i've setup msdtc correctly
on a sql 2000 cluster?


thank you
Calvin

Not dumb. Does it start? Stay running? Did you follow 817064 & 301600? You
can also use the DTCTester
http://support.microsoft.com/default...b;en-us;293799

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Calvin Do" <calvin (AT) spinsonic (DOT) com> wrote

yes, it starts and able to failover to other nodes. Thanks for the
informations, really appreciate it!


"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:%23bTHznrGFHA.2360 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

when i run the dtc tool, it gives me an error specified below. Any idea what
does this mean?

SQLSTATE=IM002,Native error=0,msg='[Microsoft][ODBC Driver Manager] Data
source
name not found and no default driver specified'

thank you
Calvin


"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:%23bTHznrGFHA.2360 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Another simple test would be to see if you start a distributed transaction.

In SQL Query Analyzer:
BEGIN DISTRIBUTED TRANSACTION
COMMIT

If it is not working then you will get
Server: Msg 8501, Level 16, State 3, Line 1
MSDTC on server yourServerName is unavailable.

hth
--
Vikram Vamshi
Eclipsys Corporation
"Calvin Do" <calvin (AT) spinsonic (DOT) com> wrote

Vikram,

thank you! it works... yippeee.....




"Vikram Vamshi" <vikram.vamshi (AT) nospam (DOT) com> wrote