0

I have a job running in one of my server and which uses a linked server and the linked server changed as part of upgrade and now my job fails everyday. I am getting the following error

OLE DB provider "SQLNCLI10" for linked server "linked server" returned message "No transaction is active.".

Msg 7391, Level 16, State 2, Line 6
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "linked server" was unable to begin a distributed transaction.

And if I directly execute the procedure in linked server from my server then, for the first time it shows this error and for the second time it execute with out any problem.

My new linked server is 2012 version and the other one is 2008 R2 version

Please let me know your thoughts?

Thanks,
Sivajith

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Sivajith
  • 1,181
  • 5
  • 19
  • 38
  • 2
    Is Microsoft Distributed Transaction Coordinator installed and enabled on both servers? not sure if it is still needed but it was needed in previous versions. – Nabheet Oct 09 '16 at 13:49

1 Answers1

0

I don't know about SQL Server 2008 R2 but in 2008 for this issue was released a fix, that is available here

gofr1
  • 15,741
  • 11
  • 42
  • 52