SQL Server Configuration Manager - How to Use SQL Server Configuration Manager to Configure Network Protocols

By: Editor
March 05, 2010

Introduction to SQL Server Configuration Manager

SQL Server Configuration Manager Tool was introduced in Microsoft SQL Server 2005. This tool can be used to manage all the SQL Server Services; it can also be used to configure network protocols that can be used by an SQL Server Instance. Moreover using this tool you can even manage the client network configurations.

You can open SQL Server 2005 Configuration Manager by typing SQLSERVERMANAGER.msc in the run command and to open SQL Server 2008 Configuration Manager you need to type SQLSERVERMANAGER10.msc in the run command.  

Managing SQL Server Services

Using SQL Server Configuration Manager you can Start, Stop, Pause or Resume SQL Server Services such as SQL Server Integration Services, SQL Server Full Text Search Service, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Database Engine Services, SQL Server Agent Service, SQL Server Browser Services etc.

Why one should Use SQL Server Configuration Manager to Change SQL Server Service Account or to Change Password?

Database Administrator should always use SQL Server Configuration Manager Tool to change SQL Server Service Account or to change the password for any of the SQL Server Services. The biggest advantage is; it performs additional configurations such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings immediately once it is changed using SQL Server Configuration Manager or SQL Server Management Objects (SMO) or using Window Management Instrumentation (WMI). The other advantage is it will come into effect immediately without the need to restart the SQL Server Service thereby helping you avoiding the downtime. Hence, you should always avoid the practice of changing the SQL Server Services account or changing password using SERVICES.MSC.

Managing SQL Server and Client Network Protocols

Database Administrator can use SQL Server Configuration Manager to configure server and client network protocols and also to change the connectivity options.



Supported SQL Server Network and Client Protocols

Microsoft SQL Server 2005 and higher versions support below mentioned network and client protocols.

1. Shared Memory
2. Named Pipes
3. TCP/IP
4. VIA

Notes: The VIA protocol is deprecated in Microsoft SQL Server 2008 and it will be removed in the future versions of Microsoft SQL Server, hence avoid using it in future development.

In the below snippet you could see the SQL Server Network Protocols. To enable a protocol right click the protocol and then select Enable option from the drop down list. To disable a protocol right click the protocol and then select Disable option from the drop down list. You need to restart the SQL Server Service for the changes to come into effect.

In the below snippet you could see the SQL Server Native Client Protocols. To enable a protocol right click the protocol and then select Enable option from the drop down list. To disable a protocol right click the protocol and then select Disable option from the drop down list.

Using SQL Server Configuration Manger you can also force protocol encryption, it also allows you to create or remove alias.

To configure force protocol encryption, expand SQL Server Network Configuration and then right click Protocols for <INSTANCE> and then select Properties. To turn on Force Encryption select the option Yes from the drop down list and click OK to save the changes.

Conclusion

In this article you have seen how easily one can configure Network / Client Protocols, can change service accounts or can update service account passwords using SQL Server Configuration Manager.

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article


Geeks who read this article also read…



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."