Groups | Blog | Home
all groups > sql server (microsoft) > january 2007 >

sql server (microsoft) : SQL Server service doesn't start


Lee w
1/31/2007 4:28:45 PM
When i try to start SQL 7 on my Windows 2000 server i get the
following message.

An error 1053 (The service did not respond to the start or control
request in a timely fashion.) occurred while performing this service
operation on the SQLServerAgent service.

I know this is vague. It happened after installed MacAfee Total
protection. I uninstalled MacAfee but the error still persists. What
should I do now?
Maninder
1/31/2007 7:11:17 PM
you can check the Password set for your SQLAgent or MSSQLService
acocunt.
Or Try to start the service as Local system account and check. If it
starts there might be a problem with the password you are trying in
your Login account.
Also check to start the service as sqlagent -c -v and check the error.

Maninder
MCDBA


[quoted text, click to view]

Lee w
2/1/2007 5:28:53 AM
When i type sqlagent -c -v this is what i get

H:\>sqlagent -c -v
Microsoft (R) SQLServerAgent 7.00.623
Copyright (C) Microsoft Corporation, 1995 - 1998.
01/02/2007 9:36:25 AM - ? [094] SQLServerAgent started from command
line
01/02/2007 9:36:25 AM - ! [359] The local host server is not running
01/02/2007 9:36:25 AM - ! [000] Unable to connect to server;
SQLServerAgent cann
ot start
01/02/2007 9:36:26 AM - ? [098] SQLServerAgent terminated (normally)


Any ideas?
Maninder
2/1/2007 8:57:51 AM
That means the SQLServer Service is not running(MSSQLService)
Try to start the SQLServer Service then Start the Agent Service
if SQL Service Dioes not start, try the -m Switch to start the
SQLServer in single user mode and then start the Agent.

is this service under a domain account or Local System.

Maninder
MCDBA
AddThis Social Bookmark Button