October 15, 2004 at 8:47 am
I have a W2K server (Server1) with SQL2000 (SP3) loaded. I have 2 linked servers (ServerA and ServerB) defined. They are each Win2003 servers with SQL2000 (SP3) loaded.
When I do this query from Server1 to ServerA, it works fine:
set XACT_ABORT ON
begin tran
update SERVERA.Northwind.dbo.Employees set FirstName = 'Anne' where EmployeeID = 9
commit
When I do this query from Server1 to ServerB, it hangs with no errors:
set XACT_ABORT ON
begin tran
update SERVERB.Northwind.dbo.Employees set FirstName = 'Anne' where EmployeeID = 9
commit
My Win2003 servers appear to be set up identically: advanced sp_configure results are identical, the DTC service is set up the same...
Does anyone have a guess at what else I could try?
The only difference between these 2 boxes is that the ServerB box has had a name and IP change in the past. (i.e. it used to be called BServer and it's IP address was changed from 20.100.10.2 to 20.100.10.3).
Thanks in advance for any help!
apf
October 18, 2004 at 8:00 am
This was removed by the editor as SPAM
October 18, 2004 at 8:38 am
There is a tool from microsoft called DTCping that can help you troubleshoot DTC problems. It will run a transaction and output any messages to a log file. I would also suspect the name change DTC is real picky about server name thats why you can sysprep an image ether.
Wes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply