The MSSQLSERVER service hung on starting.

The MSSQLSERVER service hung on starting.

Post by U3VjaG » Thu, 19 Nov 2009 22:51:03

HI All,

Win 2000 &SQL Server 2000 - 8.00.2282
DTC service is in auto start type

Recently during last system weekly reboot, the sql services hung and i see
below message in eventlogs.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7022
Date: 11/16/2009
Time: 8:11:31 AM
User: N/A
Computer: Server1
The MSSQLSERVER service hung on starting.

The SQL log has only below messages..

2009-11-16 08:39:36.21 server Copyright (C) 1988-2002 Microsoft
Corporation. 0
2009-11-16 08:39:36.23 server All rights reserved. 0
2009-11-16 08:39:36.23 server Server Process ID is 1788. 0
2009-11-16 08:39:36.23 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. 0
2009-11-16 08:39:36.32 server SQL Server is starting at priority class
'normal'(4 CPUs detected). 0
2009-11-16 08:39:36.53 server SQL Server configured for thread mode
processing. 0
2009-11-16 08:39:36.57 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks. 0
2009-11-16 08:39:37.03 server Attempting to initialize Distributed
Transaction Coordinator. 0

Please let me know the right direction to troubleshoot and how do we prevent
this happening in future?


The MSSQLSERVER service hung on starting.

Post by Uri Diman » Fri, 20 Nov 2009 18:44:21

Make sure that DTC is running