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.

  • Remotely or locally? – Erik Darling Nov 24 '17 at 0:50
  • Locally. It's my developer laptop (which is why SQL Server isn't set to auto-start.) – Jonathan Allen Nov 24 '17 at 2:22
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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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