logicalfeline
asked on
SQL Server local service starts then stops
I have SQL Server on a laptop running Windows XP Pro. I'm able to connect to the SQL Server instance on our server ok, but there seems to be something wrong with the local service on the laptop. Whenever I use the SQL Service manager to start the service it starts then automatically stops. When I try to do the same thing through the control panel services manager I get a message saying that the service started then stopped and that this happens for some services when they have no work to do.
Any ideas? PS - I am a relative SQL Server newbie.
Any ideas? PS - I am a relative SQL Server newbie.
ASKER
I don't think this has anything to do with accounts or passwords. The message I get when I attempt to start the service using Control Panel > Administrative Tools > Services is:
"The MSSQLSERVER service on local computer started then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."
I'd really rather not do a full reinstall.
"The MSSQLSERVER service on local computer started then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."
I'd really rather not do a full reinstall.
MSSQL services do not stop themselves 'if they have no work to do'. Are you using 'local system' as the account to start these services?
AustinSeven
AustinSeven
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
logicalfeline, have you checked the Event Logs to see the reason why SQL Server is stopping? Try looking into the Event Logs and post here anything that you see to give us an idea why it is stopping.
logicalfeline, were you able to solve this issue?
ASKER
Sorry I've left this question open for so long. I have had to do a full reinstall of everything on my work laptop, which as a result has cleared up the problem with SQL Server. I have awarded the points to AustinSteven for his input since reinstalling did in fact solve the problem. I am still not sure what was causing it, however.
Check the account and password used for your services on your local laptop's sql services. Most will have these set to 'Local System' and, in this case, the password won't apply. Are you using local system? In any case, these services should happily start via Control Panel, Services and, if they don't, it's most likely because of the account/password you're using. Failing all else, re-install your laptop installation of SQL Server and see if that helps.
AustinSeven