August 16, 2005 at 3:02 pm
Is anybody else seeing this error in your errorlog after applying the most recent Microsoft patches (the ones described in http://www.microsoft.com/technet/security/bulletin/ms05-aug.mspx):
Attempting to initialize Distributed Transaction Coordinator.
Failed to obtain TransactionDispenserInterface: ResultCode= 0x8004d01b
We are seeing the error after a reboot, but not if we stop and restart SQL Server. These are not clustered servers, so the info in KB article 867520 does not apply. We are on SQL Server 2000 SP3 on Windows 2000 SP4.
I have tried all sorts of distributed transactions, and haven't seen any unusual behavior.
Has anybody else seen this, and had any issues?
Thanks, Cynthia
August 17, 2005 at 7:05 am
Take a look at http://www.examnotes.net/archive79-2002-7-44933.html
The MSDTC needs to start before SQL server service. You can setup dependancies in the service control panel.
August 17, 2005 at 9:59 am
Thanks, I'll do that. Interesting that it's never been an issue prior to this recent security patch. Or, I guess it may be a case where it has always happened, and the error has just never been logged before.
In either case, since MSDTC is starting up before we kick off any distributed transactions, it really isn't a problem.
Appreciate the timely answer -- I know I can always count on this forum!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply