"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.
> > >