SQL Server Performance

Failed to obtain TransactionDispenserInterface?

Discussion in 'SQL Server Clustering' started by xuka200308, Aug 29, 2006.

  1. xuka200308 New Member

    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
  2. satya Moderator

    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.


    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page