Link to home
Start Free TrialLog in
Avatar of punjwani
punjwaniFlag for United States of America

asked on

The SQL Server Service (MSSQLSERVER) does not start and it generates error 1053

The SQL Server Service (MSSQLSERVER) does not start and it generates error 1053: 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 MSSQLSERVER service.

Service is running with Admin account.
Avatar of punjwani
punjwani
Flag of United States of America image

ASKER

SQL 2000 and Windows 2003
Avatar of Guy Hengel [angelIII / a3]
please post the relevant information of the file ERRORLOG in the msssql folder (log)
there is no errorlog file in mssql folder
have you locked in the LOG subfolder?
No there is no folder as LOG under mssql, I checked all the sub folders under C drive.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I got entry in Event Viewer for MSSQLSERVER last one was 6/7/2007

The description for Event ID ( 17177 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 556, 6/6/2007 9:54:39 AM, 6/6/2007 2:54:39 PM.
do you have Enterprise Manager?
can you check the startup parameters of the instance?
if you don't have / use Enterprise Manager, check in the registry directly:
HKLM\SYSTEM\CURRENTcontrolset\Services\MSSQLServer\

what are the entries you have there?
MSSQLServer dose not exist in registry. I think someone messedup the server
May be some other person is working to fix this, I will get back to you once I findout.
One of my collegue reinstall the SQL Server, and he made the copy of all databases including system db's so it worked fine now, angelIII you are the only one who answered my question so I am going to accept one of them.

Thanks