Follow these simple steps to start the MSSQLServer, SQLServerAgent, MSDTC, and Microsoft Search services. If you have not installed
full-text search support, you will not be able to start the Microsoft Search service, but you can start the other three.
Programs>>Microsoft SQL Server 2012>>Service Manager
from the Start menu.
- Within the dialog box, ensure that your server is selected in the Server drop-down list.
- Select MSSQLServer from the Services drop-down list. You will see the status of this service in the status bar at the bottom of the
dialog box. If the state of the service is Paused or Stopped, click the Start/Continue button to start the service.
Repeat the above procedure for the SQLServerAgent, MSDTC, and Microsoft Search (if you installed full-text search support) services. When
you've completed the steps, click the Submit
button below to receive credit for having completed the exercise and to view
a results page.