Error log message about TransactionDispenserInterface

  • I would appreciate information about the TransactionDispenserInterface if anyone is aware what it is.  I upgrade my last SQL 7 server to SQL 2000 around January 24th and I have been getting the following error in my SQL errorlog very frequently since January 25th: "Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b"

     

  • This is just an informational message meaning that the MSDTC service is

    unavailable at the time when SQL Server is started. It won't result in any

    problems with subsequent distributed transactions provided the MSDTC service is available later when the distributed transaction takes place.

    The solution is to start MSDTC before SQL Server - by manually starting MSDTC before SQL Server or explicitly setting a service dependency between SQL Server and MSDTC.


    Cheers,
    - Mark

  • Thank you so much for your reply!  The MSDTC service conflicts with an application on that server and doesn't get started, but I do have an updated version on the application that will not conflict with MSDTC.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply