MSDTC question

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@.spinsonic.com> wrote in message
news:Oiv$rNrGFHA.3076@.tk2msftngp13.phx.gbl...
> 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
>
|||yes, it starts and able to failover to other nodes. Thanks for the
informations, really appreciate it!
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23bTHznrGFHA.2360@.TK2MSFTNGP12.phx.gbl...
> 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@.spinsonic.com> wrote in message
> news:Oiv$rNrGFHA.3076@.tk2msftngp13.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@.die.spam.die.nw-america.com> wrote in
message news:%23bTHznrGFHA.2360@.TK2MSFTNGP12.phx.gbl...
> 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@.spinsonic.com> wrote in message
> news:Oiv$rNrGFHA.3076@.tk2msftngp13.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@.spinsonic.com> wrote in message
news:Oiv$rNrGFHA.3076@.tk2msftngp13.phx.gbl...
> 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
>
|||Vikram,
thank you! it works... yippeee....
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message
news:eoBwKT1GFHA.3376@.TK2MSFTNGP14.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@.spinsonic.com> wrote in message
> news:Oiv$rNrGFHA.3076@.tk2msftngp13.phx.gbl...
>
|||Actually i also facing this problem, what is the solution to fix it? Thanks for help.

Quote:

Originally Posted by Vikram Vamshi

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@.spinsonic.com> wrote in message
news:Oiv$rNrGFHA.3076@.tk2msftngp13.phx.gbl...
> 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
>