How to Use SQL Server Configuration Manager

Click here to read “How to Use SQL Server Configuration Manager to Manage SQL Server Services, Configure Network Protocols, and Network Connectivity Configuration” article from the beginning.

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.

Learn Database Backup Encryption in SQL Server 2014 a Step by Step Implementation Guide

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

Important Note: 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.

Click the below Number Buttons to continue reading the rest of the article.