Showing posts with label couldnot. Show all posts
Showing posts with label couldnot. Show all posts

Tuesday, March 27, 2012

Can't start SQLServerAgent

All of sudden, getting a Dr. Waston error with illegal
instruction on boot up.
If I tried to start it from the Services menu, get "Could
not start the SQLServerAgent service on \\server_name
Error 1067: The process terminated unexpectedly"
Do I need to reload the software... I have not found any
help in the Knowledge baseTake a closer look at the Dr Watson log to see if the SQLAgent service is
generating the Dr Watson error.
Stop any unnessary services on the machine. Leave the following running:
- Alerter
- Computer Browser
- Event Log
- License Logging Service
- Messenger
- Net Logon
- NTLM Security Support Provider
- Network Connectors
- Plug and Play
- Remote Procedure Call (RPC) Locator
- Remote Procedure Call (RPC) Service
- Server
- Spooler
- TCP/IP NetBIOS Helper
- Time Service
- Workstation
Review the NT application & System logs for hardware failure errors.
Test to see if you can start SQL Server from a command prompt.
If the problem persists and you're on the latest service pack, sp3, then
you should open up a support case.
If the Dr Watson is being caused by a bug in our product you will not be
charged for the incident.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.