Three ways SQL server starts and stops services

First, why do you want to start the SQL Server service?

1, if you do not open the service, to connect the data will appear error message

2, because not connected to the server, the database can not operate

Ii. three ways to start SQL Server

The first type: Background start service

* Specific actions: Click Computer----> Right----> Click manage----> click on "Service and app management"----> click services----> Find SQL Server (MSSQLSERVER)----> Click Start

The second type: SQL Configuration Manager Start service

* Specific operation: Find the start----> Installation path----> Configuration tool---->sql Server Configuration Manager double-click----> Click SQL Server Services----> Locate SQL Server (MSSQLSERVER )----> Click Start

Chapter III: Starting and Stopping services using commands in the Run window

Startup command: NET start mssqlserver

Stop command: net stop mssqlserver

* Specific operation: Shortcut key windows+r (appears running window)----> Input Start command: NET start mssqlserver

Three ways SQL server starts and stops services