SQL Server 2014 Tutorial – Manage SQL Server services

Problem Statement

You need to manage the SQL Server services that are installed on your server machine.

Solution

Use SQL Server Configuration Manager tool to manage the SQL Server services on your machine.

Following are some of the actions that you can perform using the SQL Server Configuration Manager
– Start , Stop , Pause , Restart a SQL Server Service
– Modify or configure the network protocols
– Modify the service accounts

To view the SQL Server Configuration Manager , select “SQL Server Server Configuration Manager” from All Apps ( or ALl Programs) from your Windows Machine.

image

This would display the “SQL Server Configuration Manager” tool.

image

To start , stop , restart the SQL Server services , follow the below steps.
– In the left pane of the SQL Server Configuration Manager , select “SQL Server Services” which would display the list of all the services available for the SQL Server.
– In the content pane (Right pane) , right click on “SQL Server(SQLExpress) and select “properties” from the context menu.
image

The SQL Server properties dialog displays several tabs to manage the services. The Logon tab has several buttons to “Start” , “stop” , “pause” and “restart” buttons which can be used to perform actions that are self explanatory.
image

To configure the protocols for SQL Server , follow the below steps

– In the left pane of the “SQL Server Configuration” , expand “SQL Server Network Configuration” and select “Protocols for SQLExpress”.

image

To enable the Named Pipes protocol , right click on the “Named Pipes” and select “enable”. The content menu also includes the properties option that lets you configure the protocol with additional options.