Distributed Transaction Error

• raj-540074

  Grasshopper

  Points: 15

  More actions

  May 8, 2008 at 11:11 pm

  #186306

  Hi buddy(s),

  I have crake my head to solve this eror for past three days...

  I need you guys help so much

  situation

  --------

  1. I have two Win XP PCs(Server A and Server B) where both running Ms SQL Server 2000. I manage to link the Server B from Server A. In both PCs I have Database A and have table named SourceTable.

  I can exute ordinary quest like below without error:

  SELECT * FROM [ServerB].DatabaseA.dbo.SourceTable

  But I face the above error when i exec distributed query for testing purpose as follow:

  SET xact_abort ON

  GO

  BEGIN DISTRIBUTED TRANSACTION

  SELECT * FROM [ServerB].DatabaseA.dbo.SourceTable

  COMMIT TRAN

  or

  SET xact_abort ON

  GO

  BEGIN TRAN

  SELECT * FROM [ServerB].DatabaseA.dbo.SourceTable

  COMMIT TRAN

  I have gone thoruh all the approach given in Microsoft KB and other forum related to this issue. But I still not manage to solve it.

  Please help me.....

  Thank you

• Zubeyir

  SSCrazy

  Points: 2559

  More actions

  May 9, 2008 at 12:43 am

  #812828

  What is the exact error message?

  You should enable the RPC on the lindek server. Right click on the linked server and go Server Options. Also you should enable the RPC on the servers.

  Zubeyir