Post reply

Failed to obtain TransactionDispenserInterface

  • February 24, 2009 at 9:10 am

    #206921

    Hi,

    Today I rebooted the Active node of cluster server, After the reboot I am seeing the below Error Messages in SQL Server 2000 ERRORLOG

    2009-02-24 05:44:11.58 server Copyright (C) 1988-2002 Microsoft Corporation.

    2009-02-24 05:44:11.58 server All rights reserved.

    2009-02-24 05:44:11.58 server Server Process ID is 21552.

    2009-02-24 05:44:11.58 server Logging SQL Server messages in file 'i:\MSSQL\MSSQL$SRVR1\log\ERRORLOG'.

    2009-02-24 05:44:11.61 server SQL Server is starting at priority class 'normal'(8 CPUs detected).

    2009-02-24 05:44:11.85 server SQL Server configured for thread mode processing.

    2009-02-24 05:44:11.89 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

    2009-02-24 05:44:12.13 server Attempting to initialize Distributed Transaction Coordinator.

    2009-02-24 05:44:14.43 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

    2009-02-24 05:44:14.50 spid4 Starting up database 'master'.

    After seeing the above error message, I checked the MSDTC service it is running fine, MSDTC was started little bit late it was started at 2009-02-24 05:59 i.e after the SQL Server service start.

    Here my question is

    1) The above error message only due to the MSDTC Service started late?

    2) is there any specific reason for the above effor message?

    3) Did any one faced the same problem?

    Thanks in Advance.

    Rajesh Kasturi

  • February 24, 2009 at 10:57 am

    #949540

    This Microsoft Support article seems to address the issue that you're experiencing:

    http://support.microsoft.com/default.aspx/kb/911845

    Thanks,

    Lori

  • February 25, 2009 at 1:32 am

    #949829

    Hi thanks for the reply,

    the KB says it is applicable to 2003 OS and AWE enabled.

    Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)

    Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)

    In my case I have Win 2000 server and AWE is not enabled.

    Rajesh Kasturi

  • February 25, 2009 at 7:49 am

    #949978

    1) The above error message only due to the MSDTC Service started late?

    Yes.

    I have experienced it in the past . I am 100% 2005 now and it has been a long time since I have rebooted my servers but I belive is not a major problem. If you can ( and need to) run distributed transactions you are OK.


    * Noel

  • February 26, 2009 at 7:24 am

    #950580

    I too agree with the above post...

    Thanks all to conclude some point

    Rajesh Kasturi

Viewing 5 posts - 1 through 4 (of 4 total)

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