SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the clients connected to an instance of SQL Server.
To launch SQL Server Configuration Manager:
1) On the Start menu, point to Programs, Microsoft SQL Server 20xx, Configuration Tools, and then click SQL Server Configuration Manager.
2) In the left pane of SQL Server Configuration Manager, expand Services.
3) To stop or start a service, right-click the service name, and then click Stop Service or Start Service.
4) To configure a service, double-click the service name. The Service dialog box appears.
5) Make any changes that you want, and then click OK.
6) In the left pane of SQL Server Configuration Manager, expand SQL Server Network Configuration.
7) To configure the protocols used by an instance of SQL Server, right-click the instance name, and then click Properties. The Protocols for <Instance Name> dialog box appears.
8) Select or clear the check boxes of the protocols that you want to enable or disable, and then click OK.
9) In the left pane of SQL Server Configuration Manager, expand Client Protocols.
10) To enable or disable a protocol, right-click a protocol name, and then click Enable or Disable.
11) To configure client protocol options, double-click a protocol name. The Protocol Properties dialog box appears.
12) Make any changes that you want, and then click OK.
13) Close SQL Server Configuration Manager.
SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the clients connected to an instance of SQL Server. You can launch SQL Server Configuration Manager from the Start menu by pointing to Programs, Microsoft SQL Server 20xx, Configuration Tools, and then clicking SQL Server Configuration Manager.
In the left pane of SQL Server Configuration Manager, you will see options for Services, SQL Server Network Configuration, and Client Protocols. To stop or start a service, right-click on the service name and click Stop Service or Start Service. To configure a service (such as changing the startup type), double-click on the service name to open the Service dialog box.
SQL Server Network Configuration is used to configure the protocols used by an instance of SQL Server. To configure the protocols, right-click on the instance name and click Properties. The Protocols for <Instance Name> dialog box appears. Select or clear the check boxes of the protocols that you want to enable or disable, and then click OK.
Client Protocols are used to manage the clients connected to an instance of SQL Server. To enable or disable a protocol, right-click on a protocol name and click Enable or Disable. To configure client protocol options, double-click on a protocol name to open the Protocol Properties dialog box.
Once you have made the changes that you want in SQL Server Configuration Manager, close the tool.
FAQs:
How do I launch SQL Server Configuration Manager?
On the Start menu, point to Programs, Microsoft SQL Server 20xx, Configuration Tools, and then click SQL Server Configuration Manager.
How do I stop or start a service in SQL Server Configuration Manager?
To stop or start a service, right-click on the service name and select Stop Service or Start Service.
How do I configure a service in SQL Server Configuration Manager?
To configure a service, double-click on the service name. The Service dialog box will appear. Make any changes that you want, and then click OK.
How do I enable or disable a protocol in SQL Server Network Configuration?
To enable or disable a protocol, right-click on the protocol name and select Enable or Disable.
How do I configure client protocol options in SQL Server Configuration Manager?
To configure client protocol options, double-click on the protocol name. The Protocol Properties dialog box appears. Make any changes that you want, and then click OK.
Conclusion:
SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the clients connected to an instance of SQL Server. You can use SQL Server Configuration Manager to stop or start a service, to change the startup type of a service, or to configure a service.