Is there a way to start SQL Server directly from SSMS?

I ask because I often go directly into SSMS, only to realize that I haven't started the SQL Server service yet. Which means either running a different app or messing around with the command prompt.

  • Remotely or locally? Nov 24, 2017 at 0:50
  • Locally. It's my developer laptop (which is why SQL Server isn't set to auto-start.) Nov 24, 2017 at 2:22

1 Answer 1


You can start the SQL Server service from SSMS Registered Servers list (View-->Registered Servers). You might need to first register the desired server (local or remote).

Right-click on the registered name and select Service control-->Start.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.