SQL Server Configuration Manager

In this tutorial you will learn about SQL Server Configuration Manager, Manage Server & Client Network Protocols, To start the default instance of SQL Server, To start an instance of SQL Server with startup options, To stop the default instance of SQL Server, To connect to another computer with SQL Server Configuration Manager, To connect to another computer with Windows Computer Management, To stop the default instance of SQL Server using net commands, To set an instance of SQL Server to start automatically and To start or Start the SQL Server Agent service

***

SQL Server Computer manager or Configuration manager mainly combines three SQL Server tools into one. Client Network utility, Server Network utility and Service manager. Provides the basic configuration management requirements of SQL Server services, Server protocols, Client protocols, client aliases, report services and report manager. SQL Computer manager is backward compatible with SQL Server 2000 and 7.0 and supports older versions of Analysis Services and Reporting services.

The SQL Server Configuration manager opens from the SQL Server Management Studio and is a snap in to the Microsoft Management console. However, it can be accessed directly from the Start Menu and added to any other Management Console display. The Microsoft Management Console draws on SQLServerManager.msc file under Windows System 32 folder to open the SQL Server configuration manager.

Windows Management Instrumentation(WMI) is used by the SQL Server Configuration Manager and SQL Server Management studio to view and change settings on the server. It provides an unified way of managing and interfacing with the API calls that manage the registry options requested by the SQL Server tools.

The Configuration Management tools can be used to start or stop, pause or resume services. Service properties can be viewed or changed. If passwords are changed using the SQL Server Configuration Manager, SMO or WMI are immediately impacted without having to restart the service.

Read More...

http://www.exforsys.com/content/view/1853/356/