Distributed Query error 7391

• Garg Manoj

  SSC Veteran

  Points: 229

  More actions

  August 31, 2005 at 11:54 pm

  #87467

  Hi all,

  I have three server running SQL server 2k and all three are having Win2K

  I have configured them as linked server on each othe.

  when I am firing a query like

  select * from [mslab-srv6].pubs.dbo.jobs

  where mslab-srv6 is the linked server it is returning the correct output.

  But when I am executing the following query

  begin distributed tran

  select * from pubs.dbo.jobs

  select * from [mslab-srv6].pubs.dbo.jobs

  commit tran

  Following Error Message is shown

  Server: Msg 7391, Level 16, State 1, Line 3

  The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

  [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

  i.e. whatever query I am giving inside "Begin Distributed Transaction" tag it is giving the same error.

  plz help me out its very urgent.

  thanks in advance.

• philcart

  SSC-Forever

  Points: 47797

  More actions

  September 1, 2005 at 1:17 am

  #586732

  Try these,

  http://support.microsoft.com/default.aspx?scid=kb;en-us;873160

  http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

   

  --------------------
  Colt 45 - the original point and click interface