how do you manually start sql server 2014

Question

During installation, I opted for manual startup of my SQL Server 2014 instance. The official MS documentation states that you should enter the following command into a command prompt to start it:

sqlservr

I tried that, as well as

sqlservr.exe

However, the command is not recognized, and running the command prompt in administrator mode doesn't work either. How do I manually start SQL Server 2014?During installation, I opted for manual startup of my SQL Server 2014 instance. The official MS documentation states that you should enter the following command into a command prompt to start it:

sqlservr

I tried that, as well as

sqlservr.exe

However, the command is not recognized, and running the command prompt in administrator mode doesn't work either. How do I manually start SQL Server 2014?

Answer 1

For Manually starting up  the SQL server 2014, it’s always recommended to  use the following command:

net start MSSQLSERVER