SQL Server Performance Forum – Threads Archive
Failed to obtain TransactionDispenserInterface?Hi All
if anyone know how to fix this issue "Failed to obtain TransactionDispenserInterface" on SQL Server log of SQL Server 2000 clustering? sometimes i got this message on the SQL server log when i test move-up on our new SQL Server 200 clustering. does it affect the clustering server? thanks for any idea, karen
Refer to this KBAhttp://support.microsoft.com/?kbid=911845 for relevant information, This is caused due to when starting up orwhen issuing a linked server query. If it is the latter, check to see if DTC is running when you encounter is error. Also check the system and application evenr logs for DTC errors. It is possible that DTC is shutting down unexpectedly. To resolve the issue follow as MSDTC seems to be dependent on order in which you started SQL services. Always MSDTC must be started before starting other services such as FULLTEXT, SQLAgent.
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.