Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4682
  • Last Modified:

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.
0
logicalfeline
Asked:
logicalfeline
  • 3
  • 2
  • 2
1 Solution
 
AustinSevenCommented:

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
0
 
logicalfelineAuthor Commented:
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.
0
 
AustinSevenCommented:
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
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
AustinSevenCommented:
A re-install isn't as difficult as you might think.  Alternatively, you could use rebuildm.exe (find in BOL) just to rebuild the system databases.  

AustinSeven
0
 
rafranciscoCommented:
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.
0
 
rafranciscoCommented:
logicalfeline, were you able to solve this issue?
0
 
logicalfelineAuthor Commented:
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.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now