Error in sql log when restarting SQL server

Error in sql log when restarting SQL server

Post by Meenal Dho » Sat, 29 Apr 2006 13:59:02


Whenever we restart sql server the following error appears:

2005-12-20 12:34:22.28 server Attempting to initialize Distributed
Transaction Coordinator.
2005-12-20 12:34:22.31 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b

When I check the MSDTC service in the SQL service manager to see if is
running - the service says it is running. Do I still have anything to worry
about?
We are running SL server 2000 sp3a.

thanks
Meenal
 
 
 

Error in sql log when restarting SQL server

Post by Sm9obiBCZW » Sat, 29 Apr 2006 16:03:02

Hi

Checking other posts it seems that this is a warning telling you that MSDTC
has not started at the time and most people seem to ignore it. You could make
the SQL Service dependent on MSDTC although this is not a usual condition and
will slow down the bootup process.

John

 
 
 

Error in sql log when restarting SQL server

Post by Meenal Dho » Sat, 29 Apr 2006 16:20:10

Many thanks
Meenal


MSDTC
make
and

worry
 
 
 

Error in sql log when restarting SQL server

Post by Muth » Tue, 16 May 2006 17:10:57


Meenal Dhody Wrote:
THis won't cause any issue because SQL server starts earlier than DTC
This happens due to chain process, that DTC depends on RPC and it take
long time.
If you able to access SQL server once it is released for use then ok
Else you can add depend on in the registry of regedt32 for sql server
Cheers,
muth