MSDTC on server unavailable

[JtheRipper]

Hi there,

I am executing a stored procedure as follows:
"
insert into jaco.dbo.sp_job_info_tbl
exec limsdev1.labware_database.dbo.sp_get_job_info
"

I do the above for about 40 servers, but I receive this error on about 3 servers:
"
Server: Msg 8501, Level 16, State 1, Line 1
MSDTC on server 'LOTUS' is unavailable.
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d01c].
"

I can execute the "exec limsdev1.labware_database.dbo.sp_get_job_info" part, but it does not want to do the insert part.

Does anyone have an idea on why I get this?


Thanks,
J.

 

[JtheRipper]

Ok, got the answer.

I had to start the "distributed transaction coordinator" service on the servers giving the problem.