DTC Fails

Please Help!...Recently we started seeing DTC failures between two of our
servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
t was working a week ago and our Network gurus say nothing has changed on the
network.
I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
in the same domain and network segment with no firewall between them. I also
added entries to the host and lmhost files on both.
I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
when run from A, but not from B (it hangs in the bind phase after
successfully completing the RPC portion but no error is retuned)The DTCTester
returns the following when run from either:
Executed: dtctester
DSN: dtctest
User Name: sa
Password:
tablename= #dtc5330
Creating Temp Table for Testing: #dtc5330
Warning: No Columns in Result Set From Executing: 'create table #dtc5330
(ival i
nt)'
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
cur
sor 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.If the 2003 server has had sp1 installed recently, this may be your
problem.You will need to change the security settings in DCOM.
"Joe Loyd" wrote:
> Please Help!...Recently we started seeing DTC failures between two of our
> servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
> t was working a week ago and our Network gurus say nothing has changed on the
> network.
> I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
> in the same domain and network segment with no firewall between them. I also
> added entries to the host and lmhost files on both.
> I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
> when run from A, but not from B (it hangs in the bind phase after
> successfully completing the RPC portion but no error is retuned)The DTCTester
> returns the following when run from either:
> Executed: dtctester
> DSN: dtctest
> User Name: sa
> Password:
> tablename= #dtc5330
> Creating Temp Table for Testing: #dtc5330
> Warning: No Columns in Result Set From Executing: 'create table #dtc5330
> (ival i
> nt)'
> 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
> cur
> sor 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.
>|||Thank you for the response! What additional settings need to be made?
"BitWise" wrote:
> If the 2003 server has had sp1 installed recently, this may be your
> problem.You will need to change the security settings in DCOM.
> "Joe Loyd" wrote:
> > Please Help!...Recently we started seeing DTC failures between two of our
> > servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
> > t was working a week ago and our Network gurus say nothing has changed on the
> > network.
> >
> > I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
> > in the same domain and network segment with no firewall between them. I also
> > added entries to the host and lmhost files on both.
> >
> > I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
> > when run from A, but not from B (it hangs in the bind phase after
> > successfully completing the RPC portion but no error is retuned)The DTCTester
> > returns the following when run from either:
> >
> > Executed: dtctester
> > DSN: dtctest
> > User Name: sa
> > Password:
> > tablename= #dtc5330
> > Creating Temp Table for Testing: #dtc5330
> > Warning: No Columns in Result Set From Executing: 'create table #dtc5330
> > (ival i
> > nt)'
> > 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
> > cur
> > sor 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.
> >
> >|||At the run command type dcomcnfg.exe
Expand Component services >> Computers >> My Computer
Right click My Computer and choose properties
Click on the MSDTC tab
Choose the Security Configuration Button
Under Transaction Manager Communication group, select No Authentication
Required
Click OK
"Joe Loyd" wrote:
> Thank you for the response! What additional settings need to be made?
> "BitWise" wrote:
> > If the 2003 server has had sp1 installed recently, this may be your
> > problem.You will need to change the security settings in DCOM.
> >
> > "Joe Loyd" wrote:
> >
> > > Please Help!...Recently we started seeing DTC failures between two of our
> > > servers. The calling server(A) is Win2003 and the destination (B) is Win2K. I
> > > t was working a week ago and our Network gurus say nothing has changed on the
> > > network.
> > >
> > > I've set the "TurnOffRpcSecurity" per KB article #827805. Both boxes are
> > > in the same domain and network segment with no firewall between them. I also
> > > added entries to the host and lmhost files on both.
> > >
> > > I downloaded and ran both DTCPing and DTCTester utilties. DTCPing succeeds
> > > when run from A, but not from B (it hangs in the bind phase after
> > > successfully completing the RPC portion but no error is retuned)The DTCTester
> > > returns the following when run from either:
> > >
> > > Executed: dtctester
> > > DSN: dtctest
> > > User Name: sa
> > > Password:
> > > tablename= #dtc5330
> > > Creating Temp Table for Testing: #dtc5330
> > > Warning: No Columns in Result Set From Executing: 'create table #dtc5330
> > > (ival i
> > > nt)'
> > > 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
> > > cur
> > > sor 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.
> > >
> > >