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 5734 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.

Leave a Comment


x

You might be Interested in these Posts

Video - Angular Router - Brian Ford

Video - Angular Router - Brian Ford http://www.youtube.com/watch?v=sfV0ApyN5fM ...

Video - An Angular2 Todo App: First look at App Development in Angular2

In this screencast , David East , one of the core contributor of the Angular provides a glimpse of A...

Video - Getting started with Angular 2

In this screencast , Alex Eagle , developer on the Angular team talks about Angular 2 developer prev...