January 24, 2004 at 10:40 am
Hello,
When trying to start the MSSQL SERVICE it fails with the following error:
MSSQL$HOUSE service on LocalComputer started and then stopped.Some services stop automatically if they have no work to do,for example, the Performance Logs and Alerts Service
It was a perfectly running system. This has started all of a sudden.
Any help is greatly appreciated.
Thanks
SK
January 24, 2004 at 8:26 pm
I guess your SQL Server has "no more work to do", go home, retire...
I know you've tried to cold restart the PC, right?
Did you install any new soft/hardware? Getting to "is there enough memory left to even attempt to start the SQL service? or has this affected the PC adversely somehow?"
What if any System Log errors are you getting after start failure?
Try: Note the Date Time stamp of the database's, and files in the MS SQL Server dir structure, then try to start the service, then after start failure, what files noted above, have changed date time stamps. There is also a Logs made by SQL when it starts, usually located in C:\Program Files\Microsoft SQL Server\MSSQL\LOG. Can you see something there? Maybe compare a "good" working log to the newest etc.
Once you understand the BITs, all the pieces come together
January 25, 2004 at 6:20 pm
Has the account that runs SQL recently had a password change or become locked out?
------------
Ray Higdon MCSE, MCDBA, CCNA
January 26, 2004 at 7:19 am
Check the account first, failing that, what events are recorded in the event logs? Look for Service Control Manager events.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply