MSDTC Doesn't seem to work

Hi,
I have a 2 node SQL 2000 Cluster
When I run the dtctester.exe I run into the following error :
================================================== ===
DSN: dtctest
User Name: ******
Password: ******
tablename= #dtc24358
Creating Temp Table for Testing: #dtc24358
Warning: No Columns in Result Set From Executing: 'create table #dtc24358
(ival int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
Driver]Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cursor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.
================================================== ====
Any help is greatly appreciated. Thanks a Lot.
Regards,
Vick
Just a quick note on it... I'm running the dtctester.exe from a different
box... So I give the sql ip address and user/passwd..
"Vick Shaw" <nospam@.msft.com> wrote in message
news:elTzA1GUHHA.868@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I have a 2 node SQL 2000 Cluster
> When I run the dtctester.exe I run into the following error :
> ================================================== ===
> DSN: dtctest
> User Name: ******
> Password: ******
> tablename= #dtc24358
> Creating Temp Table for Testing: #dtc24358
> Warning: No Columns in Result Set From Executing: 'create table #dtc24358
> (ival int)'
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
> Driver]Distributed transaction error'
> Error:
> SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server
Driver]Invalid
> cursor state
> Typical Errors in DTC Output When
> a. Firewall Has Ports Closed
> -OR-
> b. Bad WINS/DNS entries
> -OR-
> c. Misconfigured network
> -OR-
> d. Misconfigured SQL Server machine that has multiple netcards.
> Aborting DTC Transaction
> Releasing DTC Interface Pointers
> Successfully Released pTransaction Pointer.
> ================================================== ====
> Any help is greatly appreciated. Thanks a Lot.
> Regards,
> Vick
>
|||You need to properly configure DTC for Cluster and Network Connections:
http://support.microsoft.com/kb/817064/
http://support.microsoft.com/kb/301600
If you are running Win2K3 SP1, you will need to reset the DTC security
parameters:
http://support.microsoft.com/kb/899191
Since you are beginning the transaction on a remote host, that host will
also need to properly configure its DTC services.
Finally, if the communication must transit any firewalls, then you will need
to restrict RPC ports on both Client and Server for Internet Ports, and then
authorize these Ports in the firewall ACLs.
http://support.microsoft.com/kb/300083
http://support.microsoft.com/kb/250367/EN-US/
Because we authorize much of the Remote Administration utilities outbound
with an outgoing trust from our secured network, we typically configure this
restricted range to 50005100.
Good luck.
Anthony Thomas

"Vick Shaw" <nospam@.msft.com> wrote in message
news:Oo9Vr2GUHHA.4188@.TK2MSFTNGP06.phx.gbl...[vbcol=seagreen]
> Just a quick note on it... I'm running the dtctester.exe from a different
> box... So I give the sql ip address and user/passwd..
> "Vick Shaw" <nospam@.msft.com> wrote in message
> news:elTzA1GUHHA.868@.TK2MSFTNGP05.phx.gbl...
#dtc24358
> Driver]Invalid
>
|||Thanks Anthony,
After reading the KB I realize that I installed MSDTC manually on both the
cluster node by Add/Remove Widows Compenet. If I uninstall the DTC the same
way and reinstall thru the Cluster Admin it should work right ?
Thanks again..
Vick
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:u1EiXhQUHHA.4632@.TK2MSFTNGP04.phx.gbl...
> You need to properly configure DTC for Cluster and Network Connections:
> http://support.microsoft.com/kb/817064/
> http://support.microsoft.com/kb/301600
> If you are running Win2K3 SP1, you will need to reset the DTC security
> parameters:
> http://support.microsoft.com/kb/899191
> Since you are beginning the transaction on a remote host, that host will
> also need to properly configure its DTC services.
> Finally, if the communication must transit any firewalls, then you will
need
> to restrict RPC ports on both Client and Server for Internet Ports, and
then
> authorize these Ports in the firewall ACLs.
> http://support.microsoft.com/kb/300083
> http://support.microsoft.com/kb/250367/EN-US/
> Because we authorize much of the Remote Administration utilities outbound
> with an outgoing trust from our secured network, we typically configure
this[vbcol=seagreen]
> restricted range to 5000-5100.
> Good luck.
>
> Anthony Thomas
>
> --
> "Vick Shaw" <nospam@.msft.com> wrote in message
> news:Oo9Vr2GUHHA.4188@.TK2MSFTNGP06.phx.gbl...
different[vbcol=seagreen]
> #dtc24358
Server
>
|||I appologize for breaking up the response in two mails.
I enabled DTC access on both the nodes using add/remove Programs but I added
the MSDTC as a cluster resource thru the cluster Admin console... I've also
applied the required Registry settings for MSDTC (security) but still I'm
not able to get it working. Alos there are no firewalls ...
Thanks again..
Vick.
"Vick Shaw" <nospam@.msft.com> wrote in message
news:OklJjJRUHHA.4796@.TK2MSFTNGP05.phx.gbl...
> Thanks Anthony,
> After reading the KB I realize that I installed MSDTC manually on both the
> cluster node by Add/Remove Widows Compenet. If I uninstall the DTC the
same[vbcol=seagreen]
> way and reinstall thru the Cluster Admin it should work right ?
> Thanks again..
> Vick
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:u1EiXhQUHHA.4632@.TK2MSFTNGP04.phx.gbl...
> need
> then
outbound
> this
> different
> Server
>