MSSQLSERVER service terminated unexpectedly

Hi

For 15 days now my SQL server service is terminating with the following error

MSSQLSERVER service terminated unexpectedly. It has done this 2 Time(s).
This service terminates and restarts automatically and sometimes doesnt restart we have to mannuly start it again.
Event ID: 7034.

Version Details

Version: MSSQL Server 2000
Service Pack: 3a
Build: 8.0.0.760

I have checked many forums most of them suggest to apply the latest service pack. But the same error has been reported by sites having SP4 also.
Kindly help.

Thank you
wasimI'd guess a hardware problem.

Or...
...there is an infamous story at one of my old employers about a server that kept unexpectedly rebooting itself. It would always happen at about the same time each evening, but never the exact same time. The techs tried everything to figure out what was going on, but to no avail.
Finally one of the techs agreed to spend the night in the server room to observe the issue first-hand. All was quiet, until about the time the reboot was expected to occur. The tech watched as one of the late-shift workers entered the room to change the tapes. She was, shall we say, a short and portly woman, and as she bent over to eject the tape on one of the servers her derrier' smushed up against the suspect server, depressing its restart button.

Problem diagnosed and solved.

True story.|||Check the start-up account of the MSSQLServer service to see if its password has expired. Or if the account's profile has changed. Or if the service is running under credentials of an employee who has left the company.

MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
Attempting to initialize Distributed Transaction Coordinator.
.........
..............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
Suchi
Some more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:

> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causing
> the problem?
> DCOM got error "The service cannot be started, either because it is disabled
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>
|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.

MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
Attempting to initialize Distributed Transaction Coordinator.
........
.............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
SuchiSome more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:
> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causing
> the problem?
> DCOM got error "The service cannot be started, either because it is disabled
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.

MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner
Blocks.
Attempting to initialize Distributed Transaction Coordinator.
........
.............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
SuchiSome more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:

> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Own
er Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causin
g
> the problem?
> DCOM got error "The service cannot be started, either because it is disabl
ed
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server
:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.