SQL Server 2014 Tutorial – Manage SQL Server services

Published on April 3, 2016 by abundantcode

Filed under SQL Server

Last modified April 3, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 5 (1 votes)

This article have been viewed 3258 times

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.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


x

You might be Interested in these Posts

C Program to display Inverted half-pyramid using *

Problem Write a program in C to print Inverted half-pyramid using * as shown below.The program shou...

How to use array Rank in C# ?

In C# , the Rank property of the array is is used to get the rank of the array. In simple terms , ra...

How to append an array to another in JavaScript ?

In JavaScript , you may want to append one array to another array(s) to combine their elements resul...