How To Enable Sql Agent Service In 2014

Some fourth dimension you may need to apply SQL Server Configuration Manager to manage and alter the default settings of protocols and services used past SQL Server. Only, finding the configuration manager is not equally easy similar management studio. Configuration manager not an application. Instead, it is a Microsoft Direction Console (mmc.exe) snap-in. Follow these steps to launch and use SQL Server Configuration Director.

Video

Steps to open SQL Server Configuration Manager

Open up Microsoft Direction Panel (mmc) by typing in "mmc.exe" in first carte du jour. The direction panel will be launched.
In management console, become to File menu >> Add/Remove Snap-in….
In the Add or Remove Snap-ins popup window, under Available snap-ins, look for SQL Server Configuration managing director, select it and press Add> button to add the snap-in to the Panel Root. Finally press the OK button.
SQL Server Configuration Director is at present snapped in to the left panel of the MMC. You can now expand the node and see the various SQL Server services and tools for configuration.
To save the selected management console snap-in, go to the menu File >> Save.
In the Relieve As dialog, Select the folder (may be the desktop..) you desire to salvage the .mmc file and give a name to the file. Finally press Salve button.
Adjacent time when you want to open the configuration manager, you tin can just double-click the saved .mmc file to open up the MMC panel along with the snapped in SQL Server Configuration Managing director.