2

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.

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

1 Answer 1

Reset to default
4

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.

Improve this answer

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.