Hillsman
asked on
SQL Server 2000 - Unable to Start Service
OK folks,
I'm pretty sure that one of our SQL Server 2000 database instances has been corrupted for unknown reasons and that re-installation of SQL Server 2000 on the affected server is probably the only solution.
But just in case I don't actually have to go down that route (what a nightmare!), here are the errors I am getting:
Attempt to start SQLSERVERAGENT service from Admin Tools -> Services:
"Configuration Manager: A required entry in the registry is missing or an attempt to write to the registry failed" followed by "Insufficient system resources exist to complete the requested service"
Attempt to start MSSQLSERVER service from Admin Tools -> Services:
"Insufficient system resources exist to complete the requested service"
Attempt to start Database Services from SQL Server Service Manager:
"An error 3 - (The system cannot find the path specified) occurred while performing this service operation on the MSSQLServer service"
Doesn't look too good eh? The server is running Windows 2000 server - any suggestions would be much appreciated!
Many thanks,
Paul
I'm pretty sure that one of our SQL Server 2000 database instances has been corrupted for unknown reasons and that re-installation of SQL Server 2000 on the affected server is probably the only solution.
But just in case I don't actually have to go down that route (what a nightmare!), here are the errors I am getting:
Attempt to start SQLSERVERAGENT service from Admin Tools -> Services:
"Configuration Manager: A required entry in the registry is missing or an attempt to write to the registry failed" followed by "Insufficient system resources exist to complete the requested service"
Attempt to start MSSQLSERVER service from Admin Tools -> Services:
"Insufficient system resources exist to complete the requested service"
Attempt to start Database Services from SQL Server Service Manager:
"An error 3 - (The system cannot find the path specified) occurred while performing this service operation on the MSSQLServer service"
Doesn't look too good eh? The server is running Windows 2000 server - any suggestions would be much appreciated!
Many thanks,
Paul
ASKER
Hi AngelIII,
Thanks for your reply - Looks like I have the top expert on my case!
I will have a look at the registry and verify whatever filepaths I can find. Not being a total expert in these matters, may I ask what keys I should be looking at specifically? At the moment, I'm focusing on the 'Microsoft SQL Server\80' and 'MSQLServer' local machine keys.
I am not the Administrator for this particular server, but no-one else knows anything about SS so I'm having to step in! There's not a lot on there bar a few databases and a couple of publications - will these be lost if I re-run the SQL Server setup? Databases have already been backed up of course!
Thanks for your help!
Paul
Thanks for your reply - Looks like I have the top expert on my case!
I will have a look at the registry and verify whatever filepaths I can find. Not being a total expert in these matters, may I ask what keys I should be looking at specifically? At the moment, I'm focusing on the 'Microsoft SQL Server\80' and 'MSQLServer' local machine keys.
I am not the Administrator for this particular server, but no-one else knows anything about SS so I'm having to step in! There's not a lot on there bar a few databases and a couple of publications - will these be lost if I re-run the SQL Server setup? Databases have already been backed up of course!
Thanks for your help!
Paul
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
in the registry, look at:
HKLM\System\CurrentControl
the key ImagePath points to the .exe that is run when start sql server service.
HKLM\System\CurrentControl
the key ImagePath points to the .exe that is run when start sql server service.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
angelIII,
We decided that the errors were Windows-related as opposed to anything to do with SQL Server as there were issues with other services on the machine. The server was rebooted last night and everything is now up and running! No need to re-run setup then :)
You were the only person to respond so I am allocating the points to you.
Thanks for your help!
ATB,
Paul
We decided that the errors were Windows-related as opposed to anything to do with SQL Server as there were issues with other services on the machine. The server was rebooted last night and everything is now up and running! No need to re-run setup then :)
You were the only person to respond so I am allocating the points to you.
Thanks for your help!
ATB,
Paul
indeed, the path to the sql server agent program is no longer valid.
you could confirm that by checking the service information in the registry, and check if the path really is correct..