August 3, 2011 at 1:50 pm
I am running a stored procedure on sqlserver1 that calls another proc running on sqlserver 2 and I am using a distributed transaction. The stored procedure is scheduled as a job on sqlserver1 and runs in every 15 minutes. The job runs fine but now and then we get the following error and then again in the next run, the job runs fine.
Msg 7391, Sev 16, State 2, Line 94 : The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LKC1" was unable to begin a distributed transaction. [SQLSTATE 42000]
Msg 7412, Sev 16, State 1, Line 94 : OLE DB provider "SQLNCLI10" for linked server "LKC1" returned message "No transaction is active.". [SQLSTATE 01000]
Can anybody help what is happening or where can I start looking to fix this error?
Any help would be greatly aprreciated.
Thanks
August 3, 2011 at 2:00 pm
I would check first if DTC is running and configured for remote access on both servers.
August 3, 2011 at 2:14 pm
Yes, both are configured for remoted access. If it was not configured right then the job should fail all the time but it's failing with the distributed transaction error once in a while.
February 16, 2012 at 7:17 am
The job has started to fail again ...once in a while...any pointers would be greatly appreciated. thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply